Sunday, April 27, 2008

Restore a backup of a MySQL Database Server

# read the dump file back into the server

mysql db-name <>For example, to restore database called sales:

# First create the database sales:
$ mysql -u root -p

mysql> CREATE DATABASE sales;
mysql> quit;

# now restore database:
$ mysql -u root -p sales < /path/to/sales-backup-file.sql

No comments: