Automatically export MySQL database to sql file.

Automatic Backup Scheduler for MySQL can help you automatically export remote or local MySQL databases to the specified files ( use the MACRO variables to create a new file every time or overwrote the previous file ). You can easily select any MySQL database items to export, and choose to export all of the selected databases to a single file each time or export different databases to different files. The software will automatically delete the expired or the oldest exported files according to your settings.

Please follow the steps to automatically export MySQL databases to sql file :

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 Back up MySQL databases to the SQL files.
3. Enter the name of the task and click Next.

Please enter the information of the source MySQL server on Step 2 of the Task Wizard and click Next to select the databases which you want to export.

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 source MySQL server.
2. MySQL Port : The port of the source MySQL server, the default port is 3306.
3. Username: The name of the user on the source MySQL server.
4. Password: The user's password on the source MySQL server. Leave it blank if the user has no password.

Please select the databases and MySQL items which you want to export on Step 3 of the Task Wizard and click Next to choose the options for storing the exported sql files.

The software can automatically export all of updates of the selected database, it can make incremental / differential export. You can quickly choose to export Tablespaces, Table Structure or Table Records, you can set up the Advanced Settings ( Innodb, Master and Slave, flush, lock, using hexadecimal notation, etc. ) to optimize the export.


Please choose the options for storing the exported sql files on Step 4 of the Task Wizard and click Next to choose the options for uploading the backup files.
If you choose the option Back up databases to the new files every time, the software will export the selected databases to the specified folder and create new files every time. You can click Backup File Settings... to set up the options.

1. How Many Files: You can export all of the selected databases to a single file each time or export different databases to different files.
2. Backup Files: You can enter a name or use the MACRO variables to create a new sql file every time.
3. Automation Deletion: The software can automatically delete the expired exported files after some days or delete the oldest backup files every some full backup copies.

If you choose the option Always back up databases to a single same file, the software will export the selected databases to a single same file every time and the previous file will be overwrote when the task is running.

If you want to reducing the disk usage, please choose the option Compress the backup files and click Settings to set up the compress options. If you want to encrypt the exported sql file, you can compress it to ZIP with password.

1. Choose the options for uploading the exported files ( to FTP server or to Email box ) on Step 5 of Task Wizard.
2. Choose the Task Scheduler for running the task on Step 7 of Task Wizard.
3. Click Finish on Step 8 of Task Wizard to finish the task creation.

That's all. The software will automatically export the MySQL databases to the sql file.