Copy MySQL database items to a remote MySQL database automatically.

Copy MySQL database manually is really boring. If your database is very huge, select the items of MySQL database to copy is a very troublesome thing. Especially when the structure of the database changed, you have to reselect all of the items. Maybe you can try a software which can help you automatically copy MySQL database, and then enjoy your life.

Automatic Backup Scheduler for MySQL can help you automatically copy MySQL database items to a specified remote or local MySQL database with one-time set up. It can automatically copy the newly-created MySQL database items without reselect after changing the structure. You can select any items of the database to copy, or only copy the structure or records, and you can set up the advanced options ( Innodb, Master and Slave, flush, lock, using hexadecimal notation, etc. ) to optimize the copy.

Please follow the steps to automatically copy MySQL database to the other MySQL database:

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 a MySQL database to the other database.
3. Enter the name of the task and click Next.

Please enter the information of the remote MySQL server and select the database which you want to copy on Step 2 of the Task Wizard and click Next.

Souce Database: Select the database on the source MySQL server which you want to copy. Please fill out the General options before select the database, or please enter the database name.
Please select the items of the source database which you want to copy and set up the advanced options on Step 3 of the Task Wizard and click Next.

Please check the option Always back up all of updates of the current database and 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 te INSERT statements.

Easy to make the copy from InnoDB databases and tables.


And you can set up many other advanced options ( flush, lock, using hexadecimal notation, etc. ) to optimize the copy. Read More...


Please enter the information of the desitanation MySQL server and database, and select or enter the database which you want to copy to.

If your want to select an existent database on the destination MySQL server to store the source data, please check the option Select an existent database, click the arrow to select a database or enter an existent database name. ( Case Sensitive ).

If you want to create a new database to store the soure data, please check the option Create a new database. You can enter a database name or use the MACRO variables to create a new database every time. Please ensure the name is different from any existent databases. You can use the following MACRO variables:

1. %DATABASE%: The name of the source database.
2. %DATE%:The date when the destination database is created(in the "YYYY-MM-DD" format).
3. %TIME%: The time when the destination database is created(in the "HH-MM-SS" format).
   Note: You can insert any valid character(letters, figures, underline, etc.) between two MACRO variables, but please don't change the MACRO variables which are surrounded by '%'.

Note: The current MySQL user must have enough privileges to create a database on the destination MySQL server.


Please click Next and choose the Task Scheduler for running the task on Step 6 of Task Wizard to copy MySQL databases on schedule.


Click Finish on Step 7 of Task Wizard to finish the task creation.

That's all. The software will automatically copy the MySQL database items to the remote or local destination MySQL server.