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.!

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

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’ ?

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

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