How to use MySQL Administrator to backup a database

By | March 13, 2013

Use My SQL Administrator to take back up of Database

Login to My SQL administrator and enter the details, domain name has to be filled in server host, you can also use log in details of cPanel for accessing database of your account. Inway Hosting the other hand you can also apply My SQL username created through My SQL database tools of cPanel to connect to the database to which it has access. You can also leave the default value to the port settings -3306

Click on “Ok” button, after completing all details:

backup-a-database-01

After logging you can see My SQL server status on the new page. You will be able to operate administrative task like restarting My SQL server, via application on local server. How ever, you can create back ups and restore databases through this application on shared Hosting account. We provide Linux Web Hosting India

backup-a-database-02

Click on “Back UP” button located on the left side of menu, to create a backup of your database. Next click on “New Project” button and give a name to your back up, and then click on “Save Project” Button.

backup-a-database-03

After creating a project, select the database you want to back up. Mark the database from left side which indicates available databases. Then, highlight database for back up by clicking on right pointing arrow. And, Click on Execute “Back up Now” button to start back up of your database.

backup-a-database-04

Now, the application may ask for the place to store backup files of your database.  Select an appropriate location on your computer and click on “Save” button. We provide Website registration India

 backup-a-database-05

Leave a Reply