Managing MySQL databases with PHPMyAdmin in Direct Admin

Click the MySQL Management link

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to use PHPMyAdmin to manage MySQL databases

Click the phpMyAdmin link

Enter your system username and password

Then click OK

This is the PHPMyAdmin main screen

From this drop-down menu, let’s choose a database to manage

Click the SQL link

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

Click the Import link

You can run SQL queries here, but we’re not going to do that now…..

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

Let’s upload table1.sql from our local computer

Scroll down a little….

To complete the upload, click Go

Click the table1 link

We’ve successfully uploaded the table called table1.sql to the test.sql database

Click the Export link

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

Scroll down…..

Select the Save as file check box

Then click Go

Click Save

Click Yes to re-write the old table1.sql file

Click Close

We’ve just saved table1 to our computer

Click the Exit button

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

We’ve successfully signed out of PHPMyAdmin

Click the Home icon here

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