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