Hi to everyone someone know how to get an estimate about the size of one mysql table? I mean I am planning to make a backup of all the mysql's table on all my server but I'd like to know how big should be every dump table without make the physical dump. There is some command which permit to do this one? I am using mysql 5.1 on debian 6 Cheers
As seen here, you can run these queries on your database (stole from comments on the page, then tweaked).
Since a mysqldump is a logical representation of the database, you will only find actual data. Indexes are never stored in a mysqldump, but the table definition will dictate how to populate indexes.
It is hard to pickoff an exact number for a mysqldump because of what is written to a mysqldump:
What you can gauge as a factor to go by is just the sum of the data_lengths:
To see the sum by database and grand total:
To see every table and databases subtotaled:
You can use the following
You could use this Formula
Final Formula for Approximate Size of a mysqldump