MySQL Backup Using MySQL Administrator

MySQL Backup Using MySQL Administrator

MySQL Administrator will allow you to connect to your MySQL server and create a backup on your local computer.

Backup Creation

To create a backup of your database using MySQL Administrator, follow the steps below

Log into your MySQL database.

Select the backup option on the left. 

Then click on new project 

Select your database in the middle column then click on > to move that database over to create a backup.

Then click on Execute Backup now

The program will ask you where you want to save the backup. Select a directory of your choosing.  The program may take several minutes to complete the backup, depending on how much information your database has. The program may appear like nothing is happening, however it will start the backup process shortly. 

When the backup is complete there will be a .SQL file in the folder that you previously specified. 

Add Feedback