MySQL Forums
Forum List  »  Backup

Predicting mysqldump.exe output size
Posted by: Steven Hyland
Date: January 06, 2012 11:25AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Predicting mysqldump.exe output size
4917
January 06, 2012 11:25AM


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.