Digital Marketing

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 fix Google Apps Script: Script function not found: doGet

Creating sort index in MySQL

How to fix: df shows no file systems processed on Linux