How To Automatically Back Up Your MySQL Database?

Automatically Make Backup From Your Important MySQL Databases For Avoiding Data-Loss Nightmare When You Out Of The Office

  • Download and Install Auto Backup for MySQL Professional Edition

  • Operating Systems: Windows 10, 8.1, 8, 7, Vista, XP, Server 2016, 2012, 2008, 2003 and latest version.
    MySQL Version: from MySQL 4.1 to the latest version, including 4.1.x, 5.0.x, 5.1.x, 5.5.x, 5.6.x, 5.7.x, etc.
    OS of MySQL Server: All of operating systems that MySQL supported, including Unix, Linux, Windows, Mac OS, Debian, CentOS, Ubuntu, FreeBSD, Sun Solaris, Red Hat, etc.
    Task Scheduler: Minutely, Daily, Weekly, Monthly and Special Date.

    After downloading, please open the ZIP archive, double-click "mysql-backup-pro-trial.exe" program to run it, then please follow the wizard to install the software. If you want to install the Windows Service, the Administrator user is recommended.

  • Startup

  • Startup
    Please double-click the icon of the software on Windows desktop to startup the software.
    The first time you run the software, the software will display the "Create a new task" window. You may create a new task by the menu Task -> New Task every time.

  • Create Task

  • Create Task
    Please choose a task type to create a new task for backing up or restoring your MySQL databases.
    This time, please choose "Back up MySQL databases to the SQL files" task, then click "Create Task" button. The software will show a task wizard to help you create a new task, please click "Next" to continue.

  • Task Name

  • Task Name
    Please enter the unique task name, then click "Next" to continue.
    The task name contains the task type and the host name is recommended, for example, "Back Up SwordSky.com", "Restore-SwordSky.com", etc.

  • MySQL Server

  • MySQL Server
    Please enter the connection information of the source MySQL server, including Host name or IP address (e.g. www.swordsky.com, 192.168.0.101), Port (default is 3306), Username, Password, Use compression protocol, Use SSL protocol, SSL Options, Default character set (Auto-detect is recommended).
    Please grant your MySQL user account the enough privileges to access the remote MySQL server (% or the static IP address of your computer is recommended).
    Then please click "Next" to continue. The software will collect the database information from the source MySQL server and show them on the next page.

  • Backup Items

  • Backup Items
    Please select the databases, tables and views which you want to back up, and select the tablespaces, table structure and index, table records, triggers, functions, stored procedures and events if you want to back up them.
    If your MySQL user account has not enough privileges to show the database information of the MySQL server (the user has not "SHOW DATABASES" privileges), the page will show a white list without any items, please click "Enter a database" button to enter the database name of yours, the software will show the database and tables, views of its on the list automatically.
    The options "Back up all newly-created tables and views of the selected databases" and "Back up all newly-created databases on the source MySQL server" are recommended. You do not need to edit the task every time when the new tables and views are created if you select these options.
    Advanced Settings contains some advanced options to help you exactly control the process of backing up or restoring. In most cases, you do not need to change the default values of these advanced options.

  • Backup File

  • Backup File
    Please select a folder or file to store the backup files. The option "Back up data to the new files every time" is recommended, it means that the software will keep several backup archives, the old one is not overwritten.
    Click "Options - Files and name format, Create new folder and Automatically delete archives" button to set "Backup File Settings".

  • Backup File Settings

  • Backup File Settings
    On Backup File Settings window, you can select a backup file contains whole selected items, only a selected database or a table, and set the File Name Format (the macro variables %HOST%, %DATABASE%, %TABLE%, %DATE%, %TIME% are supported, and you can enter any text), create a new folder each time, automatically delete the older backup archives based on the number of copies or days.

  • Compression Options

  • Compression Options
    If you select the compression option, the software will compress the backup SQL files to the ZIP format (*.7z, *.zip) with password protection, or GZIP format (*.gz) when backing up. This option is not required for backing up your MySQL database.

  • Buffer Mode

  • Buffer Mode
    If the buffer mode is enabled, the software will speed up the backing up by buffer. This option is not required for backing up your MySQL database.

  • Task Scheduler

  • Task Scheduler
    Please choose a scheduler for running the task automatically. The software will run the task manually, minutely, daily, weekly, monthly or on the special date. Please set the run time on Settings.

  • View Task Information and Finish

  • Task Information
    Click Finish to create a new task, or click Back if you want to review or change any settings.

    Finish
    The new task is waiting for the next run time to back up your MySQL database.
    You can edit, delete, view, start, stop, run the task by toolbar or menu.

  • Install and Start Windows MySQL Backup Service

  • MySQL Backup Service Menu
    If you want the software works as a Windows Service (you do not need to log in Windows to perform the scheduled backing up and restoring), please install and start the MySQL Backup Service.
    Please choose the menu Tools -> Windows Service to show the Auto Backup for MySQL Service window, click on Install Service button to install and start the service program. The Administrator user account is recommended.
    You can install, remove, start, stop, restart, refresh the mysql backup service program on this window.

    Install MySQL Backup Service

    After installing the service program, please open Control Panel -> Administrative Tools -> Services to view the status of Auto Backup for MySQL Service. Services


  • Download and Install Auto Backup for MySQL Professional Edition