Managing Database Data with phpMyAdmin

phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner and makes editing and updating tables manually very easy.

Accessing phpMyAdmin

  • Login to cPanel
  • Click on phpMyAdmin

Once open you will be presented with your databases on the left which you just click to open and on the right will be where all of your tables show with their prefixes such as forum_, wp_ and more if you have more than one script using the same database.

Functions

The tabs at the top allow you to do many functions and operations on your database...

  • Structure displays all of the current tables in an overview
  • SQL allows you to run SQL queries and statements directly
  • Search allows you to build and perform searches within your database tables
  • Query allows you to build complex queries to run on your database
  • Export allows you to create backups of your database
  • Import allows you to import backups or other SQL files
  • Operations allows you to easily create new tables and more

If you were to check a table and select the drop-down menu at the bottom of the list you can perform a number of tasks...

  • Empty allows you to remove ALL records within the selected table(s)
  • Drop allows you to completely remove the selected table(s)
  • Print View generates a reference guide
  • Check performs error checking on your tables
  • Optimize performs a performance check and ensures data and structure are in optimum configuration
  • Repair checks for errors and repairs them if found
  • Analyze collects information about the table, validates its structure and identifies issues

Table View

Opening a table you will be able to see individual field structures within that table, by selecting a check box you can perform operations with that row including editing and more via the icons below.

For more information...

This is a very brief article covering the basics of phpMyAdmin, you should refer to http://wiki.phpmyadmin.net/pma/Articles#English and documentation available within phpMyAdmin for more in-depth information.

Disclaimer

Content and instructions found on third-party sites and services may not be complete, accurate or applicable in whole or part, reliance upon third-party content is solely at your own discretion and risk.