Menu
Recently I created a database with a name test_test in phpMyAdmin and just after I created it, the list of database on the left hand side spoiled suddenly, Is this a bug or I should ignore _ in database name?
Preview
localhost screen
On selecting
test_testdatabase
924
The rules for naming database objects (such as tables, columns, views, and database procedures) are as follows: Names can contain only alphanumeric characters and must begin with an alphabetic character or an underscore (_). Database names must begin with an alphabetic character, and cannot begin with an underscore.
Renaming a database cannot be performed directly through the phpMyAdmin area due to lack of privileges for the user. If you want to rename the database, you should create a new MySQL database, export the database tables and import them in the new one.
phpMyAdmin won't handle large database. You need to use command line to restore large database. If you don't have access, ask your server admin to restore the database.
PHPMyAdmin is grouping your databases if an underscore is used. prefix_name. They still work like usual, they are just displayed differently in PHPMyAdmin.
If you don't like it you can disable it.
199
It's not a bug, it's a feature
See http://wiki.phpmyadmin.net/pma/Config#LeftFrameDBSeparator you can change it to other pattern or disable by setting LeftFrameDBTree to false
34
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
