Managing MySQL Databases With PHPMyAdmin Print

  • 163

Let's find out how you can Manage MySQL Databases with phpMyAdmin. This article will be expecting that you are signed into your cPanel. If you are having problem doing that, please see the article named "How to Login to cPanel". On the main cPanel page, scroll down to the section called Databases, and click on the icon named phpMyAdmin. This brings you to the phpMYAdmin main screen. On the top menu bar, click on the SQL tab. This 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. As soon as you find the one you wish, click on it, click on Open, and it will take you back to the window you started at. To finish up 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.

Once 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, please click the Export in the upper menu bar. Scroll down the new window until you come to the area 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 pick which file folder you want to save it in. Choose the right one, and click Save. As soon as it is finished, a window will open confirming your download is complete. Click Close.

Any time you need help using phpMyAdmin or MySQL, you will see a handful of 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. This is the conclusion of the article. You already know how to use phpMyAdmin to manually manage a MySQL Database.

You can at this moment exit cPanel by closing your browser, or by using the Logout button in the upper right corner. Always remember, if you are using a public computer, ALWAYS Logout of cPanel before closing due to privacy reasons.


Was this answer helpful?

« Back