Predicting mysqldump.exe output size
I am having an issue determining the approximate size of the output of mysqldump.exe. I need to be able to determine this size so I can implement an accurate progress bar. For the total size of the database I have been using the byte size reported by the following query:
SELECT sum(data_length + index_length)
FROM information_schema.TABLES
WHERE table_schema = '<database name>'"
However, this number is about 8/3 times as large as the resulting dump file. Is there another way to predict the size of the dump file that mysqldump.exe produces? Is the 8/3 ratio consistent in all cases?
Subject
Views
Written By
Posted
Predicting mysqldump.exe output size
4917
January 06, 2012 11:25AM
2639
January 07, 2012 11:06AM
1594
March 19, 2012 05:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.