Go to ...

Techpository

A Better Technical Repository

RSS Feed

MYSQL: Restore a database from a mysqldump


Go to the directory that your mysqldump is located and Login:
mysql -u root -p

Create the database container if it down not already exist:
mysql> create database mydb;

Switch to using the database:
mysql> use mydb;

Restore the file:
mysql> source db_backup.dump;