MySQL backup all databases

To backup all databases on a MySQL server, run

This will create sql backup file for each database in your MySQL server on the current directory.

The first command will create a file with all database names. Second command loop through the database names and create backup using mysqldump command.

See MySQL Backup

Leave a Reply

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