MySQL Database Backup From The Command Line

On the off chance that you have utilized MySQL for some time, you have likely utilized mysqldump to backup your database. In this article, I am going to show you how to create a simple full and partial backup using mysqldump.

The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects, table data, or both. It dumps one or more MySQL database for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.

Creating MySQL Backup

The mysqldump command is used create a text file or dump the MySQL database. Dump is a simple text file with all SQL commands needed to recreate the database from scratch. Follow the below steps to make a database dump file.

Single Database Backup

If you want to take a single database backup, you can type the below command to create the dump and send the output into a file.

# mysqldump database_name > database_name.sql

Multiple Database Backup

You can also take multiple database backup, type the below command for multiple database backup.

# mysqldump --databases database_one database_two > two_databases.sql

All Database Backup

For all database base backup type the below command.

# mysqldump --all-databases > all_databases.sql

Restore MySQL Backup

Since the dump files are just SQL commands, you can restore the database backup using my below article.

• Restore Database Backup From Dump File

Thanks:)