MySQL database FAQ: How do I restore a MySQL backup? (Also written as, "How do I restore a MySQL database dump?")
Assuming that you've created a MySQL backup file as shown in my "MySQL backup - How to Backup a MySQL database" tutorial, you can use the commands shown here to restore your MySQL database. As mentioned in that article, I strongly recommend that you test your MySQL backup file by trying to restore it to another MySQL database server to make sure there are no problems with the file, and the commands shown here can be used for that test as well.
The process to restore a MySQL database from a backup file created by mysqldump is a simple two-step process:
Assuming you have the
root password for your MySQL database server, you can easily create a new database with the mysqladmin command, like this:
mysqladmin -u root -p create mytestdatabase
After you are prompted for the
root password, and successfully enter it, the
mysqladmin utility will create a new database named
mytestdatabase for you. That's all you have to do to create it.
Next, you can easily restore your old database from your backup file. Here's a command I just used to test the process of restoring a Drupal database backup file I just created with
mysql -u root -p mytestdatabase < drupaldb-20090505.sql
Warning: Be very careful with this command! In particular, you want to make sure that the database you are restoring to ("
mytestdatabase", in my case) is empty before you run this command.
In this case I am using a MySQL backup file named
drupaldb-20090505.sql to restore the contents of that database to my new database, which I named
mytestdatabase. Again, this is very simple, and that's all you have to do.
As mentioned, you can restore your database backup file using several different possible commands, but I think this command is the easiest, and I'll leave it at that for today.