Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Why underscore in my database name is spoiling phpMyAdmin database list

Tags:

php

phpmyadmin

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

enter image description here

enter image description here



On selecting test_test database

enter image description here

like image 924
Mr. Alien Avatar asked Oct 27 '12 20:10

Mr. Alien

People also ask

Can I use underscore in database name?

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.

What Cannot be done on phpMyAdmin?

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.

Can phpMyAdmin handle big data?

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.

2 Answers

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.

like image 199
Marwelln Avatar answered Sep 28 '22 02:09

Marwelln

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

like image 34
dev-null-dweller Avatar answered Sep 28 '22 02:09

dev-null-dweller
Sign in to Comment

Related questions

$_FILES array and its silly structure [duplicate]
How to handle huge form [closed]
Javascript getTime to php date
CakePHP custom validation with a variable in the error message
Conditional embed HTML between PHP code blocks?
Do integers need to be escaped
CakePHP - Loading routes files from a plugin
Add case when statement in Yii SQL command object
Magento: Select Customer Group at Registration
What is full page caching
php SimpleXML attributes are missing
conditional sql query for tables
How to know which URL failed in curl_multi_exec?
Strategies to reduce the whois query burden
PHP script language or programming language? [closed]
Call to undefined function FOS\UserBundle\Util\mb_convert_case()
jQuery File Upload by bluimp, how to replace instead of renaming
URL + htmlentities ? what to think about this?
How to get the SQL_CALC_FOUND_ROWS value using prepared statements?
No mail received in inbox with XAMPP 1.8.0, MercuryMail and mail()

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!