How to Backup MySQL Database from Master Server to Slave Automatically

It's very easy to automatically backup the important online MySQL database from a master server to a slave server using our software, Auto Backup for MySQL Professional Edition, a professional MySQL Backup Software.

First of all, please free download Auto Backup for MySQL Professional Edition

And then please install the software on your computer with Windows 7, Vista, XP, 2008 Server, 2003 Server or 2000. The software can be used to backup MySQL database from the remote server runs under Any Operating Systems, including Unix, Linux, Mac OS, Windows and all. You can install the software on the MySQL server or a client computer. It's very easy to install the software, you just need to follow some steps by an installation wizard.

After installing, please start up Auto Backup for MySQL Professional Edition, choose the menu Task -> New Task to create a new task for automatically backing up or restoring. An easy-to-use Task Wizard will help you to create a task.




Create a new task - You can create multiple scheduled task to automatically Backup MySQL database to the SQL or PHP files, Backup MySQL database to the other server ( from master server to slave ), Backup one MySQL database to the other database ( transfer all of items from a MySQL database to another existent database, or create a new database for storing ), or Restore MySQL database from all of the backups. And there are two accessories in the software, you can Export the records from some MySQL tables and views to CSV, XML, HTML, TXT files, and automatically Execute MySQL script on the destination MySQL server.



Choose a task type and click on Create Task button to start up the Task Wizard. To backup MySQL database from a master server to a slave server, please create a task to Backup MySQL database to the other server.

The software can be used to restore MySQL database on the master server from the backup database on the slave server.


Welcome Page




Step 1 - Enter task name and comment
Please enter an unique task name.




Step 2 - Choose or enter the master MySQL server information
Enter the host name or IP address, Port number, Username and Password of the source MySQL server. Please note that this is the information of the Master MySQL Server which will be backed up, is not the information of the Web Server or Slave Server.

Click New to add a new MySQL server information to the connection list. When you create task next time, you can choose a server in the connection list for avoiding duplicate input.
Click Test connection to connect to the master MySQL server and display the MySQL version.



Please grant the user account enough privileges to access the remote MySQL database (% or a specified IP address).

The software can automatically detect the Default Character Set of every database, and you can select an existent character set from the list, or enter a new one if it does not exist. The Auto-detect option is recommended. All MySQL character sets are supported, including UTF8, UCS2, LATIN1 and all.

Click Next to connect to the MySQL server and get all of information of databases and tables. It will take some time to getting these information, please wait some minutes if there are a lot of databases and tables on the MySQL server.


Step 3 - Choose databases and tables for backing up
The software lists the databases and tables which can be accessed by the user account, you can select some databases, tables or views which you would like to backup in the list. And the software can be used to backup MySQL Databases, Tables ( Table Structures and Records ), Views, Index, Stored Procedures, Triggers, Functions and Events.

All MySQL storage engines and table types are supported, including InnoDB, MyISAM, BDB and all.
All MySQL field types are supported, including BLOB, DATE, VARCHAR, DECIMAL and all.

If you do not have SHOW DATABASES privilege, please click the button Enter a database to entering the databases which will be backed up.



Backup all newly-created tables of all chosen databases: If there are some new tables are created in the chosen databases when the task running, the software will backup these new tables. If the option was not selected, these new tables will be ignored.

Backup all newly-created databases on the MySQL server: If there are some new databases with some tables are created on the MySQL server when the task running, the software will backup these new database. If the option was not selected, these new databases will be ignored.

The software can be used to backup and restore the unlimited size databases (greater than 100GB).

Click Advanced Settings to set the advanced options of the task, for example, Flush Tables, Lock Tables, Use REPLACE statements, InnoDB options, Use multiple-row INSERT syntax, HEX codes, etc.




Step 4 - Choose or enter the slave MySQL server information
Enter the host name or IP address, Port number, Username and Password of the destination MySQL server. Please note that this is the information of the Slave MySQL Server ( Backup Server ), is not the information of the Web Server or Master Server.



Please grant the user account enough privileges to access the remote MySQL database (% or a specified IP address).

Click Next to Step 5.


Step 5 - Buffer Mode Settings
Use buffer mode to speed up the task.

The records will be stored in the buffer and then write the buffer to files on hard disk.




Step 6 - Task Scheduler
Task Scheduler is used to schedule the task automatically backup or restore MySQL database Minutely ( Time Interval ), Hourly ( Time Interval ), Daily ( Every Day ), Weekly ( Every Week ), Monthly ( Every Month ) or on Special Date.










Step 7 - View task information and click Finish to create a new task




Main Window of Auto Backp for MySQL Professional Edition



The software will work for the MySQL database backup automatically as an agent.
You can run the program as a Windows Service and you don't need to log in Windows for automatic backing up.




Please enjoy our software and you will find more and more functions and features in the software.

Please free download Auto Backup for MySQL Professional Edition

Click here to learn more about How to Automatically Backup MySQL Database to SQL / PHP Files