Magento Delete All Tables Prefixed With ‘wp_’

Ever installed Magento using a one click installer and forgot to remove the “wp_” prefix ?

Simple to remove your tables ? Nope ! pesky Foreign Key Constraints !

Try this code in your favourite MySql program. Please note running the resulting SQL code this will immediately delete all of your databases prefixed with “wp_” so if you are not sure back up !

Use at your own risk.!

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) 
    AS statement FROM information_schema.tables 
    WHERE table_name LIKE 'mg_%';

Copy and paste the resultant code into your favourite MySQL GUI (Im a big fan of Navicat ) adding the below to the begining:

SET FOREIGN_KEY_CHECKS=0;

Run the code and thats it !

Dont want to delete all your tables just rename them ?

What about rename all prefixed tables from ‘mg_tablename’ to ‘tablename’ ?

SELECT  concat ('rename table ',table_name,' to ',REPLACE(table_name,'mg_',''),';')
FROM information_schema.tables
WHERE table_name like 'mg_%'
  and table_schema='your_database_name'

Again copy and paste the resultant code into your favourite MySQL GUI adding this code to the begining:

SET FOREIGN_KEY_CHECKS=0;

Warning running any resulting code could ruin your day proceed with caution.