Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does the phpMyAdmin icon (box of books?) beside certain databases mean?

Tags:

phpmyadmin

The image below is an example of the icon I am referring to. It is only present on 4 out of 50 databases.

enter image description here

like image 583
Jeff Forrester Avatar asked Jan 15 '15 03:01

Jeff Forrester


People also ask

What is phpMyAdmin and how to use it?

Let’s jump in! phpMyAdmin is an open-source tool built on PHP that enables you to administer MySQL and MariaDB databases online. To use it, you’ll need to install the software on a server running either Windows or one of the several Linux distros it supports. The software enables you to manage as many databases as you want.

How do I bookmark a query in phpMyAdmin?

Since release 2.2.0 phpMyAdmin allows users to bookmark queries. This can be useful for queries you often run. To allow the usage of this functionality: set up $cfg ['Servers'] [$i] ['pmadb'] and the phpMyAdmin configuration storage enter the table name in $cfg ['Servers'] [$i] ['bookmarktable']

Where are preferences stored in phpMyAdmin?

Since release 3.4.x phpMyAdmin allows users to set most preferences by themselves and store them in the database. If you don’t allow for storing preferences in $cfg ['Servers'] [$i] ['pmadb'], users can still personalize phpMyAdmin, but settings will be saved in browser’s local storage, or, it is is unavailable, until the end of session.

How to disable the ‘bookmarktable’ in phpMyAdmin?

enter the table name in $cfg ['Servers'] [$i] ['bookmarktable'] This feature can be disabled by setting the configuration to false. New in version 2.2.4. Since release 2.2.4 you can describe, in a special ‘relation’ table, which column is a key in another table (a foreign key). phpMyAdmin currently uses this to:


1 Answers

That indicates that two or more databases are being grouped together based on a common prefix.

By default, databases with a prefix and underscore are grouped together; so test_keys, test_tables, and test_unicode would all be grouped together under test, to get to each database you'd click the plus sign to expand them.

The separator can be configured with $cfg['NavigationTreeDbSeparator']. There's similar grouping behavior available at the table level with the configuration directive $cfg['NavigationTreeTableSeparator'], and the whole thing can be disabled by setting $cfg['NavigationTreeEnableGrouping'] = 'false';

like image 174
Isaac Bennetch Avatar answered Sep 18 '22 17:09

Isaac Bennetch