Knowledgebase

Support Center > Knowledgebase > phpMyAdmin > Known Limitations

• I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution.

  The problem is that mysqldump creates invalid comments like this: -- MySQL dump 8.22 -- -- Host: localhost Database: database...

• I cannot use (clickable) HTML-forms in fields where I put a MIME transformation onto !

  Due to a surrounding form-container (for multi-row delete checkboxes), no nested forms can be put inside the table where phpMyAdmin displays the...

• I get an error when entering USE followed by a db name containing an hyphen.

  The tests I have made with current MySQL 4.1.11 API shows that the API does not accept this syntax for the USE command. Enclosing the db name with...

• I get error messages when using "--sql_mode=ANSI" for the MySQL server

  When MySQL is running in ANSI-compatibility mode, there are some major differences in how SQL is structured (see...

• I have a table with many (100+) fields and when I try to browse this table I get series of errors like "Warning: unable to parse url". How can this be fixed ?

  Your table has neither a primary key nor an unique one, so we must use a long expression to identify this row. This causes problems to parse_url()...

• The number of records for InnoDB tables is not correct.

  phpMyAdmin uses a quick method to get the row count, and this method only returns an approximate count in the case of InnoDB tables. See...

• What are the phpMyAdmin limitations for MySQL 3 ?

  The number of records in queries containing COUNT and GROUP BY is not correctly calculated. Also, sorting results of a query like "SELECT * FROM...

• What is currently not supported in phpMyAdmin about InnoDB ?

  In relation view, being able to choose a table in another database, or having more than one index field in the foreign key. In query-by-example...

• When dumping a large table in compressed mode, I get a memory limit error or a time limit error.

  Compressed dumps are built in memory and because of this are limited to PHP's memory limit. For GZip/BZip2 exports this can be overcome since...

• When using HTTP authentication, an user who logged out can not relogin in with the same username.

  This is related to the authentication mechanism (protocol) used by phpMyAdmin. To bypass this problem: just close all the opened browser windows...

• With InnoDB tables, I lose foreign key relationships when I rename or alter a table.

  This seems to be a InnoDB bug (fixed in MySQL 3.23.50?).