Web lists-archives.com

Disk space required for taking backup




Hi All

I use mysqldump to take the backup of the entire DB. I want to know if there is way to find out how much disk space would mysqldump require to take the backup of the entire DB in .sql file.

Currently what we are doing is to check the size of the /var/lib/mysql/data directory and assuming that the size of that entire directory is what would be required for the backup .sql file but in actual terms when we take the backup into a .sql file it is much smaller in size than the size of the /var/lib/mysql/data directory.

So i wanted to know if there is a way to find out the size of file that mysqldump creates from a given DB.

Thanks
Jatin