It seems that a *.sql file I recently imported had use mysql
instead of use dbname
. Now the mysql
database contains a large number of tables which don't belong there.
Is there an easy/efficient way to clean this up?
Note: I am using MariaDB, but I think a generic answer would be more useful for others.
mysql Ver 15.1 Distrib 10.1.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2