Backup a MySQL database to the other database
Backup the selected tables from a single MySQL database to to the other database on the different or same server via TCP/IP protocol (Choose ANY database name).
Welcome Page:
Step 1: Enter task name and comment.
Step 2: Choose or enter the source MySQL server information, and choose the source database for backing up.
Click New to add a new MySQL server to the connection list.
Click Test connection to connect to the source MySQL server and display the MySQL version.
If you do not have SHOW DATABASES privilege, please enter the database into the Source Database.
Step 3: Choose tables and views of the source database for backing up.
Click Advanced Settings to set the advanced settings of the task. Advanced Settings...
Step 4: The settings of the destination MySQL server and the destination database.
Click New to add a new MySQL server to the connection list.
Click Test connection to connect to the destination MySQL server and display the MySQL version.
You may choose an existent database, or enter a database name to creating a new database.
The MACRO variables of the new database name: CASE Sensitive
%DATABASE% - This variable contains the name of the database, from which the backup copy is being made.
%DATE% - This variable contains the date of start of the backup process in the "YYYY-MM-DD" format.
%TIME% - This variable contains the time of start of the backup process in the "HH-MM-SS" format.
Step 5: Use buffer mode to speed up the task. The enough memory space is required.
Step 6: Task Schedule Settings.
Step 7: View task information and click Finish to create a new task.
