Here are the following tab functions on phpMyAdmin:

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

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. (c)

To learn more, Ask the Community >>

« Back to the Knowledgebase