Support Center > Knowledgebase > phpMyAdmin

• Bookmarks: Can I execute a default bookmark automatically when entering Browse mode for a table ?

  Yes. If a bookmark has the same label as a table name, it will be executed.

• Export: I heard phpMyAdmin can export Microsoft Excel files, how can I enable that ?

  Current version does support direct export to Microsoft Excel and Word versions 2000 and newer. If you need export older versions, you can use CSV...

• How can I backup my database or table ?

  Click on a database or table name in the left frame, the properties will be displayed. Then on the menu, click "Export", you can dump the...

• How can I create simple LATEX document to include exported table ?

  You can simply include table in your LATEX documents, minimal sample document should look like following one (assuming you have table exported in...

• How can I insert a null value into my table ?

  Since version 2.2.3, you have a checkbox for each field that can be null. Before 2.2.3, you had to enter "null", without the quotes, as the field's...

• How can I produce a PDF schema of my database ?

  First the configuration variables "relation", "table_coords" and "pdf_pages" have to be filled in. Then you need to think about your schema...

• How can I restore (upload) my database or table using a dump? How can I run a ".sql" file ?

  Click on a database name in the left frame, the properties will be displayed. Select "Import" from the list of tabs in the right–hand frame (or...

• How can I simply move in page with plenty editing fields ?

  You can use Ctrl+arrows (Option+Arrows in Safari) for moving on most pages with many editing fields (table structure changes, row editing, etc.)...

• How can I use the relation table in Query-by-example ?

  Here is an example with the tables persons, towns and countries, all located in the database mydb. If you don't have a pma_relation table, create...

• How do I set up the SQL Validator ?

  To use it, you need a very recent version of PHP, 4.3.0 recommended, with XML, PCRE and PEAR support. On your system command line, run pear...

• How to install or use an application that uses MySQL?

  In order to install or use an application that is based on a MySQL database, you have to follow this steps: Connect to your cPanel, search,...

• I want to understand some Export options.

  Structure: "Add DROP TABLE" will add a line telling MySQL to drop the table, if it already exists during the import. It does NOT drop the table...

• I would like to create a database with a dot in its name.

  This is a bad idea, because in MySQL the syntax "database.table" is the normal way to reference a database and table name. Worse, MySQL will...

• In edit/insert mode, how can I see a list of possible values for a field, based on some foreign table ?

  You have to set up appropriate links between the tables, and also set up the "display field" in the foreign table. See FAQ 6.6 for an example....

• In MySQL 4, I see a lot of databases which are not mine, and cannot access them.

  Upgrading to MySQL 4 usually gives users those global privileges: CREATE TEMPORARY TABLES, SHOW DATABASES, LOCK TABLES. Those privileges also...

• Now that phpMyAdmin supports native MySQL 4.1.x column comments, what happens to my column comments stored in pmadb ?

  Automatic migration of a table's pmadb-style column comments to the native ones is done whenever you enter Structure page for this table.

• User Management

  User management is the process of controlling which users are allowed to connect to the MySQL server and what permissions they have on each...

• What is phpMyAdmin ?

  phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL servers over the Web. Currently it can create and drop...

• What is the curious symbol ø in the statistics pages ?

  It means "average".

• When creating a privilege, what happens with underscores in the database name ?

  If you do not put a backslash before the underscore, this is a wildcard grant, and the underscore means "any character". So, if the database name...

• When I create a table, I click the Index checkbox for 2 fields and phpMyAdmin generates only one index with those 2 fields.

  In phpMyAdmin 2.2.0 and 2.2.1, this is the way to create a multi-fields index. If you want two indexes, create the first one when creating the...