Restore a MySQL database from the other database
Restore a MySQL database from the other database 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 restoring.
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 restoring.
Click Advanced Settings to set the advanced settings of the task.
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.
