Automatically restore MySQL databases from sql files to remote / local MySQL server. Ability to select MySQL databases from the SQL backup files before recovery (Reverse Parse).
Tutorials
Automatic Backup Scheduler for MySQL > Tutorials > Automatically restore MySQL databases from sql files to remote / local MySQL server.

Automatically restore MySQL databases from sql files to remote / local MySQL server.


If you want to restore MySQL database from the sql files, you can try the software Automatic Backup Scheduler for MySQL. It can help you restore the sql files to the remote / local MySQL server on schedule. With Intelligent Selection of backup files, the software will automatically remove the duplicate files, add the related backup files of the selected incremental / differential backup file, and automatically search the valid backup file ( *.sql, *.zip, *.gz, etc. ) from the selected folder and subfolder. With Reverse Parse, you can choose to restore a part of the MySQL database from the sql file before recovery.

Please follow the steps to automatically restore MySQL database from sql file to MySQL database:

Step 1: Download and install the software.
Please download and install the software Automatic Backup Scheduler for MySQL.



  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).

Step 2: Launch the software and create a task to Restore MySQL databases from the backup files.
  1. Launch the software Automatic Backup Scheduler for MySQL.
  2. Create a task to Restore MySQL databases from the backup files.
  3. Enter the name of the task and click Next.

Step 3: Select the sql files and items for recovery.
Please add the backup files ( *.sql, *.zip, *.gz, etc. ) to the list for recovery on Step 2 of the Task Wizard and click Next.
Add Backup Files

Add files to the list
Please click Add Files button to choose the backup files for recovery. The duplicate files will be removed from the list before adding. If you add an incremental/differential backup file, the software will automatically add the related backup files to the list.

Please click Add a Folder button to choose a folder for recovery. The software will automatically search the vaild backup files ( *.sql, *.zip, *.gz, etc. ) from the folder and subfolders and add them to the list. The duplicate files will be removed from the list before adding.

If the selected ZIP file is encrypted, please click the password button to enter the password.

Restore databases from ALL items in the backup files
If you choose the option Restore databases from ALL items in the backup files, all items in the backup files will be restored. You will view the backup files on Step 3 of the Task Wizard.

Select some items in the backup files for recovery
If you choose the option Select some items in the backup files for recovery, the software will Reverse Parse the backup files and extract the database structures from them. You can select the databases and items to restore from the backup files. And you can select the items on Step 3 of the Task Wizard.
Recovery Databases


Step 4: Connect the MySQL server of destination database.
Please enter the information of the destination MySQL server.
Destination MySQL Server
  1. Host Name or IP Address: The host name ( e.g. www.databasethink.com ) or IP address ( e.g. 127.0.0.1 ) of the remote MySQL server.
  2. MySQL Port : The port of the remote MySQL server, the default port is 3306.
  3. Username: The name of the user on the remote MySQL server.
  4. Password: The user's password on the remote MySQL server. Leave it blank if the user has no password.

Step 6: Click Next and follow the Task Wizard to finish the task creation.
Please click Next and choose the Task Scheduler for running the task on Step 6 of Task Wizard to restore the backup files to MySQL server on schedule.


Click Finish on Step 7 of Task Wizard to finish the task creation.

That's all. The software will automatically restore MySQL databases from the selected sql files to the destination MySQL server.

Enjoy it now!




  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).
Copyright © 2017 Database Think Software. All rights reserved.