Back Up and Restore MySQL Databases with Mysqldump


In this tutorial, How to backup and restore MySQL or MariaDB databases from the command line using the mysqldump command line.

Backup a Single MySQL Database

Use mysqldump command line to back up a single MySQL Database. Used user root to backup to save to folder as below:

mysqldump -u root -p LINUXOPERATINGSYSTEM > /tmp/LINUXOPERATINGSYSTEM-$(date +%Y%m%d).sql

Restore a Single MySQL Database

Now, I will restore a single MySQL Database to a new host MySQL Database.

Example my Database

  • File dump: /tmp/LINUXOPERATINGSYSTEM-$(date +%Y%m%d).sql
mysql -u root -p -e "create database LINUXOPERATINGSYSTEM";
mysql -u root -p LINUXOPERATINGSYSTEM < /tmp/LINUXOPERATINGSYSTEM-$(date +%Y%m%d).sql

Mysqldump Command Syntax

mysqldump <OPTIONS> > dumpfile.sql
  • OPTIONS: The mysqldump options for Backup and Restore
  • dumpfile.sql: The dump (backup) file for MySQL Database


You have to Back Up and Restore MySQL Databases with mysqldump command line. I hope will this your helpful. Thank you for reading the DevopsRoles page!


About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.