Backup and Restore MySQL Databases

By Angela Bradley, About.com Guide

If you are moving your data to a new server, or you have removed the old database completely you can restore it using the code below. This will only work if the database does not already exist:

mysql - u user_name -p your_password database_name < file_name.sql

Or using our example from the previous page:

mysql - u bobbyjoe -p happy234 BobsData < BobBackup.sql

If your database already exists and you are just restoring it, try this line instead:

mysqlimport -u user_name -p your_password database_name file_name.sql

Or using our example again:

mysqlimport -u bobbyjoe -p happy234 BobsData BobBackup.sql

Previous

• Backup Database From the Command Prompt
• Restore Database From the Command Prompt
• Backup Database From the phpMyAdmin
• Restore Database From the phpMyAdmin

Next