Setting backups
In this recipe, we will learn how to back up the MySQL database.
Getting ready
You will need administrative access to the MySQL database.
How to do it…
Follow these steps to set up the backups:
- Backing up the MySQL database is the same as exporting data from the server. Use the
mysqldump
tool to back up the MySQL database as follows:$ mysqldump -h localhost -u admin -p mydb > mydb_backup.sql
- You will be prompted for the admin account password. After providing the password, the backup process will take time depending on the size of the database.
- To back up all databases, add the
--all-databases
flag to the preceding command:$ mysqldump --all-databases -u admin -p alldb_backup.sql
- Next, we can restore the backup created with the
mysqldump ...
Get Ubuntu Server Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.