Managing MySQL Databases With PHPMyAdmin Print

  • 0

Let's learn how to Manage MySQL Databases with phpMyAdmin. This tutorial will assume that you are logged into your cPanel. If you are having trouble doing that, please see the tutorial 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 takes 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. Once you find the one you want, click on it, 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. This is the end of the tutorial. You know how to use phpMyAdmin to manually manage a MySQL Database.

You can now exit cPanel by closing your browser, or by using the Logout button in the upper right corner. Remember, if you are using a public computer, ALWAYS Logout of cPanel before closing due to security reasons.


Was this answer helpful?

« Back

SERVICES

ezyexchange  hosted microsoft exchange
ezytel  enterprise-grade hosted PBX
ezycloudsms  2-way cloud SMS
ezybroadband  NBN, wireless or fibre ethernet
ezy365  microsoft 365 licensing
ezywebhosting  enterprise web hosting
ezyssl  build trust, secure your brand
ezydomains  your name in the cloud
ezyreseller  our services, your clients


CONNECT

ezycloud | powered by Digital Hybrid
PO Box 7208, South Penrith, NSW, 2750


SALES & ENQUIRIES

Call   1300 882 942
SMS   0409 19 88 66


COPYRIGHT © 2009 -       Digital Hybrid Pty Ltd | really communicate       ACN 139 660 585   |   ABN 37 139 660 585   |   ALL RIGHTS RESERVED WORLDWIDE