Automatically copy MySQL database to a specified remote or local MySQL database, ability to select any items of MySQL and automatically copy the newly-created MySQL database items.
Tutorials
Automatic Backup Scheduler for MySQL > Tutorials > Copy MySQL database items to a remote MySQL database automatically.

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:

Step 1: Download and install the software.
Please download and install the software Automatic Backup Scheduler for MySQL.



  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).

Step 2: Launch the software and create a task to Back up a MySQL database to the other database.
  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.

Step 3: Connect the remote MySQL server and select the MySQL database which you want to copy.
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.
Source Server and Database

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.
Step 4: Select the items of the source database which you want to copy.
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.
Select Source Items

Automatically copy the newly-created MySQL databases.
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.

Copy Table Structure or Table Records? Easily to choose.
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.

Advance Settings to optimize the copy ( Innodb, Master and Slave, etc. ).
Easy to make the copy from InnoDB databases and tables.
InnoDB

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


Step 5: Connect the MySQL server of destination database.
Please enter the information of the desitanation MySQL server and database, and select or enter the database which you want to copy to.
Destination Server and Database

Select an existent database to store the source data.
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 Drop Down to select a database or enter an existent database name. ( Case Sensitive ).

Automatically create a new database to store the soure data.
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.


Step 6: Click Next and follow the Task Wizard to finish the task creation.
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.

Enjoy it now!




  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).
Copyright © 2017 Database Think Software. All rights reserved.