Knowledgebase

Managing MySQL databases with phpMyAdmin

This tutorial will assume that you are already logged into your cPanel. If you are having problems doing that or don't know how, please view the tutorial named: How to log into cPanel.

On your cPanel main page scroll down to the database section and click on the phpMyAdmin link to load the phpMyAdmin main screen. Click on the SQL tab on the top menu bar which will give you several new windows. One is called location of the text file, click on the browse button to search for a database to upload.

Once you find the one you want, click on it then click on open and it will take you back to the window you started at. To complete the upload, click go. When the upload is successfully completed you will get a screen confirming that and listing any tables found. In the left hand column any tables will be listed under the name of the database you have downloaded.

If you click on the table in the left hand column the right hand window opens with all the details of the table. To save this to your personal computer click the export in the upper menu bar. Scroll down the new window until you come to the section that says save as file. Select the check box then click go. A file download screen will open asking you if you want to save this file. Click save. In the next window (save as), you will decide which file folder you wish to save it in. Select the correct one and click save. When it is done a window will open confirming your download is complete. Click Close.

Any time you need help using phpMyAdmin or MySQL, you will find some links you can click. They are located in the left hand column of the phpMyAdmin pages.

Click the exit button (located next to the help links on the left hand column) to sign out of phpMyAdmin and return to the main cPanel page.

You can now click the home link in the upper left corner and return to the main cPanel page or to exit cPanel use the logout link in the upper right corner. Remember, if you are using a public computer, ALWAYS logout of cPanel before closing.

For additional assistance, contact us by submitting a support ticket.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Quick Navigation
Language:

Client Login:

Email

Password

Remember Me