Database Reference
In-Depth Information
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 called
•
pmadb
(phpMyAdmin database). In a multi-user
installation (discussed later), this database may be accessible to a number of
users while keeping the metadata private.
As this infrastructure does not exist by default, and because phpMyAdmin's
developers want to promote it, the interface displays the following error message
for every database when on the
Operations
subpage in the Database view:
The additional features for working with linked tables have been
deactivated. To find out why click here.
This message can be disabled with the following parameter (which, by default, is set
to
FALSE
):
$cfg['PmaNoRelation_DisableWarning'] = TRUE;
The message is the same regardless of the current database, as the
infrastructure is shared for all our databases and tables (or all users
on a multi-user installation).
Installing linked-tables infrastructure
The previous error message is displayed even if only a part of the infrastructure
is lacking. Of course, on a fresh installation, all parts are lacking—our database has
not yet heard of phpMyAdmin and needs to be outfitted with this infrastructure.
Following the
here
link in the previous message brings up a panel explaining that
the
pmadb
, and the tables that are supposed to be a part of it, are either missing
or undefined.
Search WWH ::
Custom Search