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

How to delete / clear queue of PowerMTA