MySQL database FAQ: How do I restore a MySQL backup? (Also written as, "How do I restore a
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.
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 MySQL 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’m 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.