Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: information_schema
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation
ALL_PLUGINS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
APPLICABLE_ROLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
CHANGED_PAGE_BITMAPS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
CHARACTER_SETS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
CLIENT_STATISTICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
COLLATIONS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
COLLATION_CHARACTER_SET_APPLICABILITY ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
COLUMNS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
COLUMN_PRIVILEGES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
ENABLED_ROLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
ENGINES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
EVENTS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
FILES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
GEOMETRY_COLUMNS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
GLOBAL_STATUS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
GLOBAL_VARIABLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INDEX_STATISTICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_BUFFER_PAGE ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_BUFFER_PAGE_LRU ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_BUFFER_POOL_STATS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CHANGED_PAGES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMP ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMPMEM ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMPMEM_RESET ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMP_PER_INDEX ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMP_PER_INDEX_RESET ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_CMP_RESET ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_BEING_DELETED ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_CONFIG ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_DEFAULT_STOPWORD ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_DELETED ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_INDEX_CACHE ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_FT_INDEX_TABLE ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_LOCKS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_LOCK_WAITS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_METRICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_MUTEXES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_COLUMNS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_DATAFILES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_FIELDS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_FOREIGN ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_FOREIGN_COLS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_INDEXES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_SEMAPHORE_WAITS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_TABLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_TABLESPACES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_SYS_TABLESTATS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_TABLESPACES_ENCRYPTION ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_TABLESPACES_SCRUBBING ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
INNODB_TRX ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
KEY_CACHES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
KEY_COLUMN_USAGE ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
PARAMETERS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
PARTITIONS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
PLUGINS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
PROCESSLIST ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
PROFILING ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
REFERENTIAL_CONSTRAINTS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
ROUTINES ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
SCHEMATA ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
SCHEMA_PRIVILEGES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
SESSION_STATUS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
SESSION_VARIABLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
SPATIAL_REF_SYS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
STATISTICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
SYSTEM_VARIABLES ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
TABLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
TABLESPACES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
TABLE_CONSTRAINTS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
TABLE_PRIVILEGES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
TABLE_STATISTICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
TRIGGERS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
USER_PRIVILEGES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
USER_STATISTICS ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
VIEWS ~0 This view has at least this number of rows. Please refer to documentation. Aria utf8_general_ci
XTRADB_INTERNAL_HASH_TABLES ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
XTRADB_READ_VIEW ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
XTRADB_RSEG ~0 This view has at least this number of rows. Please refer to documentation. MEMORY utf8_general_ci
78 tables Sum ~0 InnoDB utf8_general_ci

Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
array,
NULL,
NULL,
)
./libraries/Util.class.php#4791: PMA_DatabaseInterface->getTablesFull(
string 'hmis',
boolean false,
boolean false,
NULL,
integer 0,
boolean true,
string 'Name',
string 'ASC',
NULL,
)
./db_structure.php#26: PMA_Util::getDbInfo(
string 'hmis',
string '',
)
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'hmis\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
array,
NULL,
NULL,
)
./libraries/Util.class.php#4791: PMA_DatabaseInterface->getTablesFull(
string 'hmis',
boolean false,
boolean false,
NULL,
integer 0,
boolean true,
string 'Name',
string 'ASC',
NULL,
)
./db_structure.php#26: PMA_Util::getDbInfo(
string 'hmis',
string '',
)
Warning in ./libraries/dbi/DBIMysqli.class.php#261
Error while sending QUERY packet. PID=1296674

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()