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.


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


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




Django-Python Web based application developer.

Share This Post

Related Articles

Leave a Reply

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