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:

Please download and install the software Automatic Backup Scheduler for MySQL.

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.

Please add the backup files ( *.sql, *.zip, *.gz, etc. ) to the list for recovery on Step 2 of the Task Wizard and click Next.

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.

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.

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.


Please enter the information of the 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.

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.