[Discuss] mysql brain teaser...

Stephen Adler adler at stephenadler.com
Sun Feb 26 09:17:35 EST 2012


Check this out for a mysql brain tease.... I'm working on a new database 
project and on my development system I run a separate mysql database 
server to develop against. So today I found the following in my list of 
databases in my development mysql database server.


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| #mysql50#.emacs.d  |
| clinicaldb         |
| mysql              |
| performance_schema |
| test               |
+--------------------+
6 rows in set (0.00 sec)

So what is this #mysql50#.emacs.d database? I did a quick search and 
found that #mysql50# prefix means that a database was upgrade which my 
have happened as I've upgraded through various releases of Fedora. But 
the .emacs.d is the weird part. The database contains `.` characters 
which are supposidly not allowed according to the following link

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

does anyone have a suggestion as to how I can check to see what tables 
are in this database and/or how to drop the database?

Thanks in advance...

Cheers. Steve.




More information about the Discuss mailing list