Plesk 8 (Linux) end-user series

25. Managing MySQL databases with PHPMyAdmin

This demo assumes you've already logged in to Plesk

Let's learn how to manage MySQL databases with PHPMyAdmin

1) Click the Databases link here

2) Select the database you wish to manage, by clicking it here

3) To enter PHPmyAdmin, click the DB WebAdmin icon here

4) Click the customers link here, as this is the database we wish to manage

Welcome to the PHPmyAdmin main page

5) Click the SQL link

There are currently no tables in this database, as indicated here

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

6) Let's import an existing table..... click Browse

7) Select the table you wish to import.....

8) Then click Open

9) Click Go

10) Click Export

table1 which was in test.sql has been successfully imported

Now let's learn how to export this table.....

Scroll down

11) Select the Save as file check box

12) Then click Go

13) Click OK

We've just saved table1

Let's return to the main PHPmyAdmin page

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

To exit PHPmyAdmin, simply close the browser window

This is the end of the tutorial. You now know how to use PHPMyAdmin to manually manage MySQL databases