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