April 10

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;

Copyright 2021. All rights reserved.

Posted April 10, 2012 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B