How to Restore a Backup of a MySQL Database Server

In this article, i will show you how to backup/restore mysql from remote server, steps are very simple. You can just copy & paste to do your jobs. This help is on linux system with command line how to. You can do it by navicat tool or MySQL GUI, but i still like terminal command line.

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 by using the following command:

$ mysql -u root -p sales < /path/to/sales-backup-file.sql

That's all.