Sun. Dec 8th, 2019

How to Backup and Restore MySQL Database

1 min read

In the previous article, I shared how to create a mysql database in Linux. Today, on this post, I’m going to guide you on how to backup and restore the mysql database.

Backup mysql database

Using below command:

mysqldump –opt -u [uname] -p [dbname] > [backupfile.sql]

Parameter:

  • [uname]: user in a database
  • [dbname]: database name
  • [backupfile.sql]: backup filename
  • [–opt]: mysqldump options

Example:

mysqldump -u root -p meterpreter > db_meterpreter.sql

Restore mysql database

Using below command:

mysql -u [uname] -p [dbname] < [backupfile.sql]

Parameter:

  • [uname]: user in a database
  • [dbname]: database name
  • [backupfile.sql]: sql backup file

Example

mysql -u root -p meterpreter < db_meterpreter.sql