O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Linked-tables infrastructure

The relational system's infrastructure is stored in tables that follow a predetermined structure. The data in these tables is generated and maintained by phpMyAdmin on the basis of our actions from the interface.

Goal of the infrastructure

Metadata tables contain, for all storage engines, information to support the special phpMyAdmin's features such as bookmarks and transformations. Moreover, for tables in a storage engine that does not support foreign keys, relations between tables are kept in this infrastructure.

Location of the infrastructure

There are two possible places to store these tables:

  • A user's database—to facilitate every web developer owning a database to benefit from these features.
  • A dedicated database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required