phpMyAdmin configuration storage settings

phpMyAdmin Configuration Storage settings are given below.
1)   bookmarktable
2)   column_info
3)   designer_coords
4)   favorite
5)   history
6)   navigationhiding
7)   pdf_pages
8)   recent
9)   relation
10) table_coords
11) savedsearches
12) table_info
13) table_uiprefs
14) tracking
15) userconfig
16) usergroups
17) users


1) bookmarktable
RELATED TABLES: pma__bookmark, pma_bookmark
Allows to bookmark MySQL queries that are run oftenly.


2) column_info
RELATED TABLES: pma__column_info, pma_column_info
Allows to store comments that describes a column.
These comments are…
• Shown on the printview.
• Used on the table property pages where they show up as tool-tips or in table browse view where they are embedded within the header of table in browse view.
• Stored and shown in a table dump.
• Provide support for a MIME-transformation system based on column comments.


3) designer_coords
RELATED TABLES: pma__designer_coords, pma_designer_coords
Provides a Designer interface which permits to visually manage the relations.


4) favorite
RELATED TABLE: pma__favorite

Allows to store the favorite tables.
NOTE: phpMyAdmin’s setup script does not provide a way to set this option. Also phpMyAdmin’s Main documentation does not have an entry on this.


5) history
RELATED TABLES: pma__history, pma_history
Allows to store manually entered MySQL queries into the phpMyAdmin interface.


6) navigationhiding
RELATED TABLE: pma__navigationhiding
Allows to hide/show items in the navigation tree


7) pdf_pages
RELATED TABLES: pma__pdf_pages, pma_pdf_pages
Allows to create PDF pages showing the relation between tables.
For this feature to work, we also need the below.
• Storing coordinates where each table will be placed on a PDF schema output OR the table_coords feature.
relation feature.


8) recent
RELATED TABLE: pma__recent
Store the list of recently used tables through all login sessions. This list is shown in the left navigation panel and helps us to jump across table directly, without the need to select the database.


9) relation
RELATED TABLES: pma__relation, pma_relation
Allows to describe which column is a key in another table.
This can be used for the following.
• Make the data values that point to the foreign table clickable, when we browse the master table.
• Display in an optional tool-tip the display column when browsing the master table.
• Display a drop-down list of possible foreign keys in edit/insert mode, with information about key value and display column.
• Display links on the table properties page, to check referential integrity(display missing foreign keys) for each described key.
• Create automatic joins in query-by-example.
• Enable us to get a PDF schema of our database by working in conjunction with table_coords feature.


10) table_coords
RELATED TABLES: pma__table_coords, pma_table_coords
Allows to describe the table positions for the PDF schema.


11) savedsearches
RELATED TABLE: pma__savedsearches
Allows to store the saved searches.
NOTE: phpMyAdmin’s Main documentation does not have an entry on this.


12) table_info
RELATED TABLES: pma__table_info, pma_table_info
Allows to describe which column is to be displayed as a tool-tip when moving the cursor over the corresponding key.


13) table_uiprefs
RELATED TABLE: pma__table_uiprefs
Stores the sorted columns, column order and column visibility for browsing tables, through all login sessions.


14) tracking
RELATED TABLES: pma__tracking, pma_tracking
Tracks every SQL command executed by phpMyAdmin. This mechanism supports logging of data manipulation and data definition statements.
It also enables us to create versions of tables. The created versions include structure and indexes, and all commands(linked to version numbers) which change the structure and/or data of the table. We can also view the tracked changes with complete report for every version. We can also view specific information from report using filters or export the report to a file or to a temporary database.


15) userconfig
RELATED TABLES: pma__userconfig, pma_userconfig
Allows to store user preferences through all login sessions.


16) usergroups
RELATED TABLE: pma__usergroups
Allows to store menu items for each user group


17) users
RELATED TABLE: pma__users
Allows to store users and their assignments to user groups.




You may go back to the following section.
Installing phpMyAdmin