Tweet
Managing MySQL databases with phpMyAdmin in cPanel
what is cpanel
This tutorial will guide you on how to manage MySQL databases with phpMyAdmin in cPanel. For the purpose of this guide, we'll presume that you're currently in cPanel hosting and therefore are viewing the primary display.
Let us begin to learn how to manage MySQL databases with phpMyAdmin in cPanel. Scroll down the cPanel hosting screen and select the phpMyAdmin icon underneath the Databases category within your cPanel hosting. Once you have selected phpMyAdmin a new display will appear the phpMyAdmin main screen.
Let's choose 'test' as the database we wish to manage on the left hand side of the screen. Since there are currently no tables in this database, as indicated here, we can create a new table here; but we will not proceed with that at this point.
Select the SQL tab on the top of the screen. Then select Browse so we can search for a database to upload. Let's upload the test.sql database we've previously saved by selecting test.sql and then select open. To complete the upload, click Go. The SQL query has been executed successfully of the database called test.sql, which now has a table called table1 in it.
On your left hand side of the screen under the database test(1), select the table named table1. On this page you will see all the details of table1 within the database test.sql.
We shall now learn how to save the table1 to our personal computer. Select the Export tab on the top of the screen. Scroll down the page and select Save as file box then select the Go button. A security warning will appear for you to select if you wish to save this file or not; select Save and Save again in the Save in File. You will see that table1 has successfully been saved by the small pop-up window stating Download Complete. Select Close.
If at any time you wish for help within phpMyAdmin or MySQL you may select one of the help buttons (the button with a ? or the button with SQL) located on the top left hand side of the screen.
Now select the green Exit button located on the top left of the screen, next to the home button and before the help buttons. We have now successfully signed out of phpMyAdmin main screen and returned to cPanel hosting page. This is the end of the tutorial. You now know how to manage MySQL databases with phpMyAdmin in cPanel.
If you need any further assistance on how to manage MySQL databases with phpMyAdmin in cPanel,
please feel free to ask them on this thread!
How to install FrontPage extensions in cpanel
Comment