How to drop database with # in name in MySQL

By default any folders inside the mysql data directories will be read as database and will be shown in "show databases".

You can escape database names using backtick quotes to drop it:

DROP DATABASE `#mysql50#lost+found`;

Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows

Fixed: ImportError: No module named utilities.common.tools