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: Input task name and comment.
Step 2: Choose or input 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.
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 input 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.
