Run SQL Query to Determine the Size of MySQL Databases

[Eli]

Running one of these SQL queries will give you the size of all databases in MB:

Code: [Select all] [Expand/Collapse]

1. SELECT table_schema,
2.         ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
3. FROM "DB Name" information_schema.TABLES
4. GROUP BY table_schema;

Code: [Select all] [Expand/Collapse]

1. SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema

Or

Code: [Select all] [Expand/Collapse]

1. SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 / 1024 AS "Size (GB)" FROM information_schema.TABLES GROUP BY table_schema

to get size in GB.


You can however specify the database by replacing DB Name with the actual database if you want to check the size of a specific database.

Ref: DB Queries

[Eli]

Once you know the size, you can then make sure you export the correct size of your database for backup:

To create a backup of your MySQL Database:

• Log in to cPanel.
• In the Files section, click on the Backups icon.
• Under Partial Backups, look for Download a MySQL Database Backup, and then click the name of the specific database you want to backup.
• Wait for the download to complete.

See more

https://www.hostgator.com/help/article/ ... phpmyadmin