Backup and Restore MySQL DB Using mysqldump

Posted on by By Sayali Mahale, in Databases | 0

mysqldump is a tool used to backup MySQL Database.

  • It creates .sql file having DROP TABLE , CREATE TABLE , INSERT INTO TABLE sql Statements.
  • To restore the database we have to execute the .sql file on destination database.
  • Using mysqldump command you can backup a local database and can restore it on remote database.

We will now see how to backup and restore MySQL database using mysqldump.

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] > dumpfilename.sql

How to Backup MySQL database

  • Backup a single Database

# mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

  • Backup multiple Databases

# mysqldump -u root -p[root_password] [database_name1] [database_name2]…[database_nameN] > dumpfilename.sql

  • Backup all Databases

# mysqldump -u root -p[root_password] —all-databases > all-database.sql

  • Backup a single Table

# mysqldump -u root -p[root_password] [database_name] [table_name] > tablename.sql

  • Backup multiple Tables

# mysqldump -u root -p[root_password] [database_name] [table_name1] [table_name2]…[table_nameN] > tablename.sql

How to Restore MySQL database

  • Restore a Database

1.Create Database Using Command:
# mysql -u root -p root_password
mysql> create database database_name;

2. Restore a Database
# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

  • Restore a Table

1.Create Table Using Command:
# mysql -u root -p root_password
mysql> create table table_name;

2. Restore a table
# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

This way , you can Backup and restore a MySQL Database.

Thanks ,
Sayali Mahale


Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments