Browse
 
Tools Add
Rss Categories
-->

Managing MySQL with PHP Admin (Unskinned)

Reference Number: AA-00880 Created: 2012-09-20 13:23 Last Updated: 2012-10-08 13:21 0 Rating/ Voters

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.

Image:Php.JPG

You'll see the phpMyAdmin main screen.

Image:Ms.JPG

3) Let's choose "test" as the database we wish to manage.

Image:Test.JPG

There are currently no tables in this database, as indicated by the notice: "No tables found in database."

Image:Not.JPG

We can create a new table here, but we're not going to do that now.

Image:Ct.JPG

4) Click the SQL link.

Image:Sql.JPG

5) Then click Browse so we can search for a database to upload.

Image:Brw.JPG

Let's upload the test.sql database we've previously saved.

Image:Prev.JPG

6) To complete the upload, click Go.

Image:Go.JPG

We've successfully uploaded a database called test.sql, which has a table called table1 in it.

Image:Ta1.JPG

7) Click table 1.

Image:Clta.JPG

On this page, you can see all the details of table1 within the database test.sql.

Image:Page.JPG

Now let's learn how to save the table1 table to our personal computer.

8) Click the Export link.

Image:Exprt.JPG

9) Scroll down.

10) Select the Save as file check box.

Image:Savfile.JPG

11) Then click Go.

Image:Gol.JPG

12) Click Save.

Image:Clsa.JPG

13) Click Save again.

Image:Sva2.JPG

We've just saved table1.

14) Click Close.

Image:Close.JPG

If at any time you want help with using PHPMyAdmin or MySQL, click on one of the help links.

Image:Help.JPG

15) Click the Exit button.

Image:Exit.JPG

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.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: