Loading ...Two simple commands to export and import (backup and restore) mysql database
phpMyAdmin is a great web based tool. However, I ran into issues with it when you try to export and import but the database is growing too big. You will likely run into error similar to the following:
Allowed memory size of 67108864 bytes exhausted (tried to allocate 32231548 bytes) in ... zip.lib.php
If you are lucky enough that your hosting provides you with SSH access, you can use the following two commands to export and import your database
milly 10:10 pm on January 28, 2010
1. SSH into your hosting account.
2. To export (backup), run this command:
mysqldump -u USER_NAME -p DATABASE_NAME -h DB_HOST_NAME > db_export.sqlMake sure you replace “USER_NAME”, “DATABASE_NAME”, “DB_HOST_NAME” with the settings in your setting.3. To import (restore) the backup database, run the following command:
mysql -u USER_NAME -p DATABASE_NAME -h DB_HOST_NAME < db_export.sqlMake sure you replace “USER_NAME”, “DATABASE_NAME”, “DB_HOST_NAME” with the settings in your setting.