MySQL Backup Using MySQL Administrator
MySQL Administrator will allow you to connect to your MySQL server and create a backup on your local computer.
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
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.