Mysql database backup (different file sizes)


#1

I hope someone can shed some light on this. I only have one mysql database.

When I view the database via Dreamhost’s Webpanel under Manage MySql it states my database is 229mb in size.

When I go into phpmyadmin and export the database (uncompressed) as a .sql file, the database comes out to be 134mb. Looking at the list of tables in phpmyadmin and counting their sizes it seems to come close to this size.

When I log in via shell and use this command:

mysqldump --opt -uusername -ppassword -h yourMySQLHostname dbname > filename.sql

the database comes out to be 78 megabytes.

Furthermore any type of compression via Phpmyadmin’s export does not work.

Any clues on what is the correct size???


#2

This is the original size of your database. Including table structures and data.

When you export a databse, the .sql file only contains the scripts to create the tables and to insert the data. Of course, it will be much smaller than the origianl database.

[quote]When I log in via shell and use this command:

mysqldump --opt -uusername -ppassword -h yourMySQLHostname dbname > filename.sql

the database comes out to be 78 megabytes.[/quote]
I’m not sure about this. This is also a .sql file which contains the installation scripts. I guess it is smaller because there are NO empty lines between the scripts.

$50 off and 3 free domains with code: [color=#CC0000]DH3[/color] Sign Up NOW or More Codes Here