I'm moving my local installation of Magento to a dev location on my hosting server. FTP is the easy part.
I created a new database on the hosting server, then connected via HeidiSQL. I exported my database from my local to the hosting server with no problems that I could tell (no errors reported) but I noticed that when I compared the two databases in size, local is 102mb but hosted is 86mb. I figured something went wrong, so I dropped all the tables in the hosted mysql to start over.
Second attempt was the same outcome, so I tried a different way. I used the Magento backend to make a backup of the database. Once I had the backup, I did the required modifications - removing the /*!40101 and */ at the beginning and end of the sql file, and uploaded it via PHPMyadmin.

Again, everything seemed to go off without a hitch, but when I accessed the database again via HeidiSQL, same problem, the database on the hosting server is smaller than local.

Am I missing something? Will this new smaller database still work?

  • If everything is working I wouldn't worry about the minor difference in size.
    – SR_Magento
    Commented Mar 17, 2017 at 12:20
  • Whelp! So far it's not working. Layout is broken and no navigation. Commented Mar 17, 2017 at 12:47
  • I would attempt dumping the DB with the mysql command line interface. Then importing with the CLI as well.
    – Ryan Cady
    Commented Mar 17, 2017 at 15:35

1 Answer 1


If you have SSH access to both server, I would use mysql dump to back up the database.

mysqldump --single-transaction database_name > database_name-`date +%Y%m%d%H%M%S`.sql

Then FTP the file to the new server

Then run

mysql New_DataBase < database_name-xxxxxxx.sql to import

You can then rerun the dump to check the sizes. Use this all the time and works without a hitch.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.