Restore MySQL databases from the other server

Automatically restore the remote or local MySQL databases from the other MySQL server with a powerful task scheduler.

• Create a task: Create a Restore MySQL databases from the other server task.
• Welcome Page: Welcome to the Task Wizard.
• Step 1 - Task Name: Enter the name and the comment of the task.
• Step 2 - Source MySQL Server: Enter the information of the source MySQL server.
• Step 3 - Select Databases: Select the databases.
• Step 4 - Destination MySQL Server: Enter the information of the destination MySQL server.
• Step 5 - Execute SQL Script: Enter the SQL script for running.
• Step 6 - Task Scheduler: Choose the scheduler for running the task.
• Step 7 - Task Information: View the task information and Finish to create a task.

Create a task
Double click the item or select the item and then click Create Task button to create a new task.


Welcome Page: Welcome to the Task Wizard! Please click Next to continue, or Cancel to exit.


Step 1 - Task Name: Enter the name and the comment of the task. Please do not enter an existent task name even if the original task had already been moved to the category Deleted Tasks. Please view the existent task in the category "All Avtive Tasks" or "Deleted Tasks".


Step 2 - Source MySQL Server: Enter the information of the source MySQL server. The software will restore the databases from the source MySQL server to the destination MySQL server. How to set up the options of Source MySQL Server?


Step 3 - Select Databases: Select the databases which you want to restore, set up the Advanced Settings and Tablespaces option. How to set up the options of the databases?


Step 4 - Destination MySQL Server: Enter the information of the destination MySQL Server. The software will restore the databases from the source MySQL server to the destination MySQL server. How to set up the options of Destination MySQL Server?


Step 5 - Execute SQL Script: Enter the SQL script for running. The software can execute SQL statements before and after restoring. How to set up the options for Executing the SQL Script?


Step 6 - Task Scheduler: Choose the scheduler for running the task. The task will run on schedule with professional Task Scheduler ( Minutely, Daily, Weekly, Monthly, and with the Begin date and End date ). How to set up the options of Task Scheduler?


Step 7 - Task Information: View the task information. Click Finish to create a task, or click Back if you want to review or change any settings.


After clicking Finish, a new Restore MySQL databases from the other server task will be created. It will automatically appears in the Task List.

---

See also:

1. Task - Back up MySQL databases to the SQL files
2. Task - Back up MySQL databases to the other server
3. Task - Back up a MySQL database to the other database
4. Task - Restore MySQL databases from the backup files
5. Task - Restore a MySQL database from the other database
6. Task - Execute SQL Script
7. Page - MySQL Server
8. Page - Source Server and Database
9. Page - Destination Server and Database
10. Page - Select Databases
11. Page - Select Source Items
12. Page - Add Backup Files
13. Page - Recovery Databases
14. Page - Backup Files
15. Page - Upload Backup Files
16. Page - Execute SQL script before starting and after ending
17. Page - Enter SQL Script
18. Page - Task Scheduler
19. Options - MySQL Database Advanced Settings
20. Options - Backup File Settings
21. Options - Compression Options
22. Options - Back up Tablespaces
23. Options - SMTP Options
24. Protocol - SSL Protocol
25. Protocol - SSH Tunneling