Different size of database backup

Different size of database backup

Posted by: RCD
Posted on: 2006-02-24 15:13:00

Hi!

When i make a db backup with the shell:

mysqldump --opt -uusername -ppassword -hyourMySQLHostname dbname > output.sql


I get one output.sql file of 25 Megas


But if i make the same backup with phpmyadmin, then I get a file of 55 Megas.

Why?
What's wrong?


I made the 2 backups with this instructions:
http://wiki.dreamhost.com/index.php/Migrate_MySQL#Creating_the_MySQL_Backup



Tags: database backupmysqldumpoptshell