Web lists-archives.com

Estimate mysqldump size




Hello,

Is there a way that gives an estimate of the size of a mysqldump such a
way that it would always be larger than the real size?

So far, I have found:

   mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM
      information_schema.tables WHERE table_schema NOT IN
      ('information_schema','performance_schema','mysql');

but the result may be smaller than the real size.

I am writting a program that takes the result of mysqldump and pipe it
in a tar file. Tar file format has the size in the header, before the
data and if the size of the dump is bigger than the size declared in the
header, tar does not like that (if the size of the dump is smaller than
the actual size, it can be padded with spaces).

So, the estimate must be larger than the actual dump, how to acheive
that?

Thanks in advance,

Olivier


-- 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql