Knowledgebase: MySQL
Manage MySQL databases with PHPMyAdmin
Posted by on 28 October 2013 05:11 PM

It's easy to learn how to manage MySQL databases with phpMyAdmin.

Let's get started:

  1. Log in to your cPanel account
  2. Click PHPMyAdmin in the Databases section
  3. Click Test in the left-hand side of your screen in the gray shaded area
  4. Click the SQL tab then click Browse in the Location of the text file section
  5. Upload the .sql database you've previously saved and click Go
  6. View the newly updated table from the MySQL file you just uploaded in the left-hand side shaded gray section (it will view underneath Test)
  7. Click that table link under Test, that you just uploaded
  8. To save the table to your computer click the Export tab near the top right
  9. Tick Save as file and click Go, then Save in the dialog pop-up box that appears
  10. Click Save again to save your table, and then click Close
  11. Click Exit to sign out of PHPMyAdmin

If you want help using the PHPMyAdmin or MySQL click one of the helpful links under the PHPMyAdmin header at the top left that look like a '?' and 'SQL' (they are small thought bubbles in the gray shaded area to the left of your screen.)

 

For more information on managing your MySQL database with PHPMyAdmin, check out this video tutorial: http://www.cirtexhosting.com/tutorials/x3/cpanel-x3-phpmyadmin.html.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion