competence-rs.com / localhost

Recent

Favorites

There are no favorite tables.

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x-

Server: localhost

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

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

Export defaults
SQL
CodeGen
CSV
LaTeX
Microsoft Office
OpenDocument
Texy! text

Export defaults

Customize default export options.

Quick
Export method
Save on server
Overwrite existing file(s)
Custom
Format
Compression
Character set of the file
Use `LOCK TABLES` statement
Export as separate files
Save as file
Save on server
Overwrite existing file(s)
Table name template
Database name template
Server name template

SQL

Customize default options.

Structure
Comments
Creation/Update/Check dates
Relations
MIME type
Enclose export in a transaction
Disable foreign key checks
Export views as tables
Export related metadata from phpMyAdmin configuration storage
SQL compatibility mode
Dump table
Add DROP DATABASE
Add CREATE DATABASE / USE
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER
Add CREATE TABLE
Add IF NOT EXISTS (less efficient as indexes will be generated during table creation)
Add AUTO_INCREMENT value
Add CREATE VIEW
Add CREATE PROCEDURE / FUNCTION / EVENT
Add CREATE TRIGGER
Enclose table and column names with backquotes
Data
Use delayed inserts
Use ignore inserts
Export type
Syntax to use when inserting data
Maximal length of created query
Use hexadecimal for BINARY & BLOB
Export time in UTC

CodeGen

Customize default options.

Format

CSV

Customize default options.

CSV
Columns terminated with
Columns enclosed with
Columns escaped with
Lines terminated with
Replace NULL with
Remove CRLF characters within columns
Put columns names in the first row
CSV for MS Excel
Replace NULL with
Remove CRLF characters within columns
Put columns names in the first row
Excel edition

LaTeX

Customize default options.

Structure
Include table caption
Dump table
Table caption
Continued table caption
Label key
Relations
Comments
MIME type
Data
Put columns names in the first row
Table caption
Continued table caption
Label key
Replace NULL with

Microsoft Office

Customize default options.

Microsoft Word 2000
Dump table
Replace NULL with
Put columns names in the first row

OpenDocument

Customize default options.

OpenDocument Spreadsheet
Put columns names in the first row
Replace NULL with
OpenDocument Text
Dump table
Structure
Relations
Comments
MIME type
Data
Put columns names in the first row
Replace NULL with

Texy! text

Customize default options

Data
Dump table
Replace NULL with
Put columns names in the first row

Export templates:

Export method:

Quick - display only the minimal options
Custom - display all possible options

Format:

Databases:

Select all / Unselect all

Output:

Rename exported databases/tables/columns
Save output to a file
- File name template:This value is interpreted using strftime, so you can use time formatting strings. Additionally the following transformations will happen: @SERVER@ will become the server name. Other text will be kept as is. See the FAQ for details.use this for future exports
- Character set of the file:
- Compression:
- Export databases as separate files
View output as text

Skip tables larger thanMiB

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 *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
object,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#1354: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
array,
NULL,
object,
)
./libraries/display_export.lib.php#913: PMA_DatabaseInterface->getColumnsFull(
NULL,
NULL,
NULL,
object,
)
./libraries/display_export.lib.php#881: PMA_getHtmlForAliasModalDialog(
string '',
string '',
)
./libraries/display_export.inc.php#75: PMA_getHtmlForExportOptions(
string 'server',
string '',
string '',
string '<div><a href="#" onclick="setSelectOptions(\'dump\', \'db_select[]\', true); return false;">Select all</a> / <a href="#" onclick="setSelectOptions(\'dump\', \'db_select[]\', false); return false;">Unselect all</a><br /><select name="db_select[]" id="db_select" size="10" multiple="multiple"> <option value="herp" selected="selected">herp</option> <option value="hmis" selected="selected">hmis</option> <option value="phpmyadmin" selected="selected">phpmyadmin</option> <option value="test" selected="selected">test</option> </select></div>',
string '',
array,
string '',
)
./server_export.php#30: require_once(./libraries/display_export.inc.php)

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 *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
object,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#1354: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `COLLATION_NAME` AS `Collation`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `PRIVILEGES` AS `Privileges`, `COLUMN_COMMENT` AS `Comment` FROM `information_schema`.`COLUMNS`',
array,
NULL,
object,
)
./libraries/display_export.lib.php#913: PMA_DatabaseInterface->getColumnsFull(
NULL,
NULL,
NULL,
object,
)
./libraries/display_export.lib.php#881: PMA_getHtmlForAliasModalDialog(
string '',
string '',
)
./libraries/display_export.inc.php#75: PMA_getHtmlForExportOptions(
string 'server',
string '',
string '',
string '<div><a href="#" onclick="setSelectOptions(\'dump\', \'db_select[]\', true); return false;">Select all</a> / <a href="#" onclick="setSelectOptions(\'dump\', \'db_select[]\', false); return false;">Unselect all</a><br /><select name="db_select[]" id="db_select" size="10" multiple="multiple"> <option value="herp" selected="selected">herp</option> <option value="hmis" selected="selected">hmis</option> <option value="phpmyadmin" selected="selected">phpmyadmin</option> <option value="test" selected="selected">test</option> </select></div>',
string '',
array,
string '',
)
./server_export.php#30: require_once(./libraries/display_export.inc.php)

Warning in ./libraries/dbi/DBIMysqli.class.php#261

Error while sending QUERY packet. PID=3174540

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()

SQL upload ( 0 ) x-

Exporting databases from the current server

Export templates:

New template:

Existing templates:

Export method:

Format:

Databases:

Output:

Format-specific options:

PDF

Dump table

CSV

CodeGen

LaTeX

Dump table

Object creation options

Data dump options

PHP array

SQL

Object creation options

Data creation options

YAML

Microsoft Word 2000

Dump table

Data dump options

JSON

MediaWiki Table

Dump table

OpenDocument Text

Dump table

Object creation options

Data dump options

CSV for MS Excel

OpenDocument Spreadsheet

Texy! text

Dump table

Data dump options