How to back up MySQL database automatically?

Are you looking for a software which can back up MySQL database automatically? The software Automatic Backup Scheduler for MySQL can help you automatically back up MySQL database to the SQL files, the other MySQL server or database on schedule. In this tutorial, we will focus on back up MySQL databases to the other server.

Automatic Backup Scheduler for MySQL is an easy-to-use and professional automated MySQL backup and recovery software. The software ability to select any items of MySQL database and automatically back up the newly-created MySQL databases. It can make full/incremental/differential backup on schedule. When an error occurs the software will send you an email with the error report.

Please follow the steps to automatically back up MySQL databases to the other server:

Please download and install the software Automatic Backup Scheduler for MySQL.

1. Launch the software Automatic Backup Scheduler for MySQL.
2. Create a task to Back up MySQL databases to the other server.
3. Enter the name of the task and click Next.

Please enter the information of the source MySQL server on Step 2 of the Task Wizard and click Next.

1. Host Name or IP Address: The host name ( e.g. www.databasethink.com ) or IP address ( e.g. 127.0.0.1 ) of the remote MySQL server.
2. MySQL Port : The port of the remote MySQL server, the default port is 3306.
3. Username: The name of the user on the remote MySQL server.
4. Password: The user's password on the remote MySQL server. Leave it blank if the user has no password.

Please select the MySQL databases and items on the source MySQL server which you want to back up, set up the advanced options on Step 3 of the Task Wizard and click Next.

If you check the option Always back up all of updates of the current database, the software will automatically add the newly created items and remove the dropped items from the source database list of the task for copying, you don't need to edit the task manually.

If you check the option Table Structure, the software will copy the structure of the selected tables, those are the CREATE table statements.

If you check the option Table Records, the software will copy the records of the selected tables, those are the INSERT statements.

There are three backup types for the backup tasks: MySQL Full Backup, Incremental Backup and Differential Backup. Differential Backup is not available in the Back up MySQL databases to the other server task. Please click Settings... to set up the Incremental/Differential Backup Options if you choose it.

You can click Advanced Settings... (flush, lock, using hexadecimal notation, Innodb, Master and Slave, etc.) to optimize the backup.

Please click Backup Tablespaces... to choose if back up the tablespaces or not. You can back up all of Tablespaces or back up Tablespaces for the selected databases and tables, or don't back up any Tablespaces.

1. Enter the information of the destination MySQL server on Step 4 of the Task Wizard.
2. Enter the SQL Script for running on Step 5 of the Task Wizard.
3. Choose the Task Scheduler for running the task on Step 6 of the Task Wizard.
4. Click Finish on Step 7 of Task Wizard to finish the task creation.

That's all. The software will automatically back up the MySQL database to the other remote or local MySQL server.