Restore MySQL databases from the backup files - Automatic Backup Scheduler for MySQL

Task Wizard

Automatic Backup Scheduler for MySQL > Help Document > Task Wizard > Restore MySQL databases from the backup files

Restore MySQL databases from the backup files

Automatically restore the remote or local MySQL databases from the backup files with a powerful task scheduler. You can select databases from the SQL files when recovery ( Reverse Parse ).

Create a task: Create a Restore MySQL databases from the backup files task.
Welcome Page: Welcome to the Task Wizard.
Step 1 - Task Name: Enter the name and the comment of the task.
Step 2 - Add Backup Files: Add the backup files for recovery.
Step 3 - Recovery Files: View the files you selected to recovery.
Step 3 - Recovery Databases: Select some items for recovery.
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 1

Step 2 - Add Backup Files: Add the backup files ( *.sql, *.zip, *.gz, etc. ) for recovery. How to set up the options of Adding Backup Files?
Step 2

Step 3 - Recovery Files: If you choose the option Restore databases from ALL items in the backup files on Step 2, you can view the files you selected to recovery.
Step 3

Step 3 - Recovery Databases: If you choose the option Select some items in the backup files for recovery on Step 2, the software will Reverse Parse the backup files and extract the database structures from them. You can select the databases and items ( Tables, Views, Triggers, Stored Procedures, Functions and Events ) which you wish to restore from the backup files for recovery. How to set up the options of Recovery Databases?
Step 3

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

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 5

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 6

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.
Step 7

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