Automatically export MySQL database to specified sql file.
Tutorials
Automatic Backup Scheduler for MySQL > Tutorials > Automatically export MySQL database to sql file.

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 :

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 Back up MySQL databases to the SQL files.
  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.

Step 3: Connect the source MySQL server.
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.
Source 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 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.

Step 4: Select the databases and MySQL items.
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.
Select Databases

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.


Step 5: Choose the options for storing the exported sql files.
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.
Backup Files Options

Export MySQL databases to the new file every time.
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.
Backup Files Settings
  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.

Export MySQL databases to a single same file.
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.

Compress the exported files to GZ / ZIP with password.
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.


Step 5: Click Next and follow the Task Wizard to finish the task creation.
  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.

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 © 2024 Database Think Software. All rights reserved.