SHOW DATABASES seems somehow slow on ISPs
how about using I_S.SCHEMA_PRIVILEGES
LIMIT 0 , 30
performs much faster on the ISP i could test:
0.08 sec vs. 0.24 seconds
possible this will only work with ISPs where are no anonymous rights
possible a configuration where ISP can use I_S.SCHEMA_PRIVILEGES instead of
SHOW DATABASES, or they can switch to SHOW DATABASES like '[user]_%' which
performs much faster too
$cfg['DatabaseListQuery'] = 'SHOW DATABASES';
// #user# is replaced by curent user
$cfg['DatabaseListQuery'] = "SHOW DATABASES LIKE '#user#%'";
$cfg['DatabaseListQuery'] = 'SELECT DISTINCT TABLE_SCHEMA FROM
we got a few requests about this. Probably the most common generator of
CSV files is MS Excel, and this fine application, when saving as CSV,
generates a semi-colon separated file with no possibility of specifying
the enclosing character (at least in the default dialog, I did not dig
But phpMyAdmin refuses to import it (see subject). I deactivated the
message in my copy of PMA then imported some simple sample data
(removing the double quotes in the CSV dialog), it went fine so I am
tempted to get rid of this validation but would like to hear your comments.
can you add some red bold blinking screen filling hint on the edit pages
that this is not the right place to ask questions about phpMyAdmin?
they should use the ways mentioned on http://wiki.cihar.com/pma/Getting_Help
as an example for export plugins, I hacked export to Texy! format.
However now I can not decide whether it is worth of inclusion in
phpMyAdmin. You can see sample output in Texy! demo (textarea
contains exported text, bellow it is rendered by Texy!).
What do you think? Should I commit it or not? :-)
Michal Čihař | http://cihar.com | http://blog.cihar.com