Knowledgebase
Knowledgebase: MySQL & PostgreSQL
How do I backup my MySQL database locally?
Posted by Diego Cousinet on 21 February 2011 11:37 AM

Step 1. Click Here to go to Control Panel and log into you account using your Username and Password

 

Step 2. Click on the MySQL 5.5 Databases option under Services tab

 

Step 3. Click on Admin link next to the username that you wish to administrate the database as

 

Step 4. In the opening window, click on the Databases button to get a list of the databases in a drop down box, then click the database name you want to back up in the left-hand pane of the page

 

Step 5. Click the Export tab in the navigation links toward the top of the page

 

Step 6. Select the Custom - display all possible options option under the Export Method heading

 

Step 7Scroll down to the Object creation options heading and enable the Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement option

 

Step 8. Scroll to the bottom of the page and click the Go button

 

(51 vote(s))
Helpful
Not helpful

Comments (0)