Categories
DBA

Removing all databases from a MySQL instance « MySQL Preacher

Many out there will have different ideas about this, some using procs, some using a function, others using a shell script. Well I didn’t want to spend much time on it so decided a group_concatconcat would be enough.There is no genius, rather laziness : but what if you have a hundred databases and you want to drop them all?

via Removing all databases from a MySQL instance « MySQL Preacher.

The PAGER option is most intriguing