How to Backup or Restore MySql Database in Ubuntu platform?

Hi Friends,

I’m always spending some 10 or 15 minutes for searching commands to Mysql Backup and Restore. It may reduce your time.

Here is the commands to Backup and Restore.

Backup

mysqldump -u username -p password your_database_to_backup > backup_name.sql

Restore

Open/Connect MySql via terminal

mysql -u username -p

Create Database

CREATE DATABASE database_name;

Now, restore Mysql in created Database

mysql -u username -p password database_name < backup_name.sql

Cheers!

 

 


Django-Python Web based application developer.

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups