Managing MySQL databases with phpMyAdmin in cPanel for VPS (Unskinned)
Click here for a video tutorial
Managing MySQL databases with phpMyAdmin in cPanel.
This demo assumes you've already logged into cPanel.
Let's learn how to manage MySQL databases with phpMyAdmin.
1) Scroll down.
2) Click the phpMyAdmin icon.
You'll see the phpMyAdmin main screen.
3) Let's choose "test" as the database we wish to manage.
There are currently no tables in this database, as indicated by the notice: "No tables found in database."
We can create a new table here, but we're not going to do that now.
4) Click the SQL link.
5) Then click Browse so we can search for a database to upload.
Let's upload the test.sql database we've previously saved.
6) To complete the upload, click Go.
We've successfully uploaded a database called test.sql, which has a table called table1 in it.
7) Click table 1.
On this page, you can see all the details of table1 within the database test.sql.
Now let's learn how to save the table1 table to our personal computer.
8) Click the Export link.
9) Scroll down.
10) Select the Save as file check box.
11) Then click Go.
12) Click Save.
13) Click Save again.
We've just saved table1.
14) Click Close.
If at any time you want help with using PHPMyAdmin or MySQL, click on one of the help links.
15) Click the Exit button.
We've successfully signed out of phpMyAdmin.
This is the end of the tutorial. You now know how to use phpMyAdmin to manually manage a MySQL database.