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???