Restore a backup of a MySQL Database Server
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
Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
Related Linux / UNIX FAQ:
- How can I restore a backup of a MySQL database?
- Import MySQL dumpfile, SQL datafile into my database
- MySQL empty database / delete all tables
- Mysql user creation - setting up a MySQL new user account
- Create a mysql database, tables and insert data
Discussion on This FAQ
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Please do not use the comment form to ask for help / question. Ask your question on the excellent Linux tech support forum. Thank you very much for stopping by our site!
Tags: command line tool, mysql command line, mysql database server, mysqldump_command, mysql_command, restore database, sql statement ~ Last updated on: November 12, 2007
November 12th, 2007 at 4:04 am
mysql> quite;should be:
mysql> quit;(without the e)November 12th, 2007 at 5:55 am
thanks for the heads up.