Restore a backup of a MySQL Database Server

by on November 10, 2007 · 2 comments· LAST UPDATED November 12, 2007

in , ,

Q. How can I restore a backup of a MySQL database server made with mysqldump program discussed here?

A. You can use standard mysql - the MySQL command-line tool to restore a backup of a MySQL database server.

Read back dump file

You can read the dump file back into the server like this:
mysql db-name < backup-file.sql

To restore database called sales, first create the database sales:
$ mysql -u root -p
Now create database called sales using SQL statement:

mysql> CREATE DATABASE sales;
mysql> quit;

Now restore database, enter:
$ mysql -u root -p sales < /path/to/sales-backup-file.sql



If you would like to be kept up to date with our posts, you can follow us on Twitter, Facebook, Google+, or even by subscribing to our RSS Feed.


{ 2 comments… read them below or add one }

1 Ben November 12, 2007 at 4:04 am

mysql> quite;
should be:
mysql> quit; (without the e)

Reply

2 vivek November 12, 2007 at 5:55 am

thanks for the heads up.

Reply

Leave a Comment

You can use these HTML tags and attributes for your code and commands: <strong> <em> <ol> <li> <u> <ul> <kbd> <blockquote> <pre> <a href="" title="">

Tagged as: , , , , , ,

Previous Faq:

Next Faq: