Creating MySQL Backup
In this tutorial in will show you how to backup mysql database.
The mysqldump command is used to create textfile “dumps” of databases managed by MySQL. These dumps are just files with all the SQL commands needed to recreate the database from scratch. The process is very quick and easy.
Read Also: How to install mariadb on centos?
If you want to create backup of one database or single database, execute the following command:
mysqldump -u username -p databasename > backup.sql
If you want take backup of multiple databases execute following command:
mysqldump -u username -p database1 database2 > backup.sql
If you want to take backup of all databases use:
mysqldump -u username -p --all-databases > fullbackup.sql
Read Also: How to create mysql database and tables?
Read Also: Restoring mysql database
If you have any issue using this tutorial Please feel free to Comment below.
Read Also: Create mysql user from command line
Leave a Reply