Backups for MySQL Databases

Backups for MySQL Databases

In order to create a backup of your MySQL database on your dedicated server you will need a program like MySQL Workbench.  This Knowledge Base Article will detail the steps to install and connect to your MySQL database with MySQL Workbench.

MySQL Workbench Installation

First, download and install MySQL Administrator. See KB Article 873 for instructions on setting up MySQL Workbench on the server.

After MySQL Workbench is properly installed, please follow these steps to setup backups for the MySQL Database.

Setting up Backups

In MySQLAdmin, go to Tools > Options.

Select Administrator on the Left.

Uncheck "Add Date/Time to Backup Files".

Select General Options on the Left.

Under Password Storage select "Store passwords."  Change the Password storage method to "Obscured" and click apply.

Select Connections and create a new connection.

Name the connection backups and supply your root login information and put the hostname as localhost. Apply the changes and exit the options window.

Log out of MySQLAdmin and then log back in using your newly created stored connection.

Scheduling the Backup

From the MySQLAdmin Panel select Backup.

On the Backup Project Tab, click the New Project Button on the bottom and create a Project Name.

From the Schemata window highlight the MySQL database you wish to backup and click the > button.

Select the Schedule Tab.

Check "Schedule this backup project" and change the Target Folder Location to "C:\mysqlbackups\"  Name the filename the same as your database.

Under Execution Time section, choose Execute Backup Daily and change the Time to 21:00.

Select Save Project.

When prompted for Account Information, use your current Windows Login account. (This is used for the Window's Scheduled task.)

This process will backup the database nightly for you. Repeat the Scheduling the Backup steps for each database you wish to backup.

Add Feedback