Currently phpMyAdmin can: PHPMyAdmin
  1. browse and drop databases, tables, views, columns and indexes
  2. create, copy, drop, rename and alter databases, tables, columns and indexes
  3. maintenance server, databases and tables, with proposals on server configuration
  4. execute, edit and bookmark any SQL-statement, even batch-queries
  5. load text files into tables
  6. create1 and read dumps of tables
  7. export1 data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel and LATEX formats
  8. import data and MySQL structures from Microsoft Excel and OpenDocument spreadsheets, as well as XML, CSV, and SQL files
  9. administer multiple servers
  10. manage MySQL users and privileges
  11. check referential integrity in MyISAM tables
  12. using Query-by-example (QBE), create complex queries automatically connecting required tables
  13. create PDF graphics of your Database layout
  14. search globally in a database or a subset of it
  15. transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  16. track changes on databases, tables and views
  17. support InnoDB tables and foreign keys (see FAQ 3.6)
  18. support mysqli, the improved MySQL extension (see FAQ 1.17)
  19. communicate in 58 different languages
  20. synchronize two databases residing on the same as well as remote servers (see FAQ 9.1)

Linked-tables infrastructure

bookmarks, comments, SQL-history, tracking mechanism, PDF-generation, column contents transformation, etc.

./scripts/ directory, where you should find a file called create_tables.sql. O

specify the table names in your ./config.inc.php file. in the Configuration section

store SQL queries

all queries are recorded in a table, or JavaScript (history is lost when closing the window) [available since 2.5.0] . $cfg['Servers'][$i]['history'] string
$cfg['QueryHistoryMax'] amount of history items on hold. On login, this list gets cut to the maximum amount. (query history requires JavaScript enabled ).
To allow the usage of this functionality:
  1. set up pmadb and the linked-tables infrastructure
  2. put the table name in $cfg['Servers'][$i]['history']
  3. $cfg['Servers'][$i]['tracking'] string

log all SQL commands

Track SQL commands executed by phpMyAdmin, data manipulation and data definition statements. After enabling create versions of tables. Since release 3.3.x .

The creation of a version has two effects:

  1. phpMyAdmin saves a snapshot of the table, including structure and indexes.
  2. phpMyAdmin logs all commands which change the structure and/or data of the table and links these commands with the version number.
view the tracked changes On the "Tracking" page a complete report is available for every version. use filters, for example list of statements within a date range.
To filter usernames enter * for all names or enter a list of names separated by ','.
export the (filtered) report to a file or to a temporary database.

To allow the usage of this functionality:

  1. set up pmadb and the linked-tables infrastructure
  2. put the table name in $cfg['Servers'][$i]['tracking']
  3. $cfg['Servers'][$i]['tracking_version_auto_create'] boolean
Whether the tracking mechanism creates versions for tables and views automatically. Default value is false. If this is set to true and you create a table or view with
CREATE TABLE ...
CREATE VIEW ...
and no version exists for it, the mechanism will create a version automatically.

$cfg['Servers'][$i]['tracking_default_statements'] string
Defines the list of statements the auto-creation uses for new versions. Default value is :
CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE, CREATE INDEX,DROP INDEX, INSERT,UPDATE,DELETE,TRUNCATE,REPLACE, CREATE VIEW,ALTER VIEW,DROP VIEW, CREATE DATABASE,ALTER DATABASE,DROP DATABASE

$cfg['Servers'][$i]['tracking_add_drop_view'] boolean A DROP VIEW IF EXISTS statement will be added as first line of the log when creating a view. Default true.

$cfg['Servers'][$i]['tracking_add_drop_table'] boolean A DROP TABLE IF EXISTS statement will be added as first line of the log when creating a table. Default true.

$cfg['Servers'][$i]['tracking_add_drop_database'] boolean A DROP DATABASE IF EXISTS statement will be added as first line of the log when creating a database. Default true.