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 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