WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I´m building a WP Multisite for a client that wants a multilingual site. Before choosing WP Multisite, I bought and tried out WPML. However that plugin didn't fit for the job so I deleted it and got a refund.

However, now this seems to come back pestering me somehow. Now when using Multisite, I have been using Backupbuddy to export and duplicate my site for different testing purposes. Now some trouble has appeared, the database is friggin huge despite this being a very small page!

The SQL is a wooping 500 megs, I can't even see it in MyPhpAdmin. I got the SQL-file on my desk and when I finally got it open, its bloated everywhere with remnants of WPML tables that seems to have been duplicated with every site duplication, but never removed upon site deletion.

Has anyone encountered this? I´m no good at database editing and really unsure of how I can fix this.

share|improve this question

closed as off-topic by Pieter Goosen, s_ha_dum Oct 15 '14 at 22:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 3 down vote accepted

First of all i wouldn't use phpmyadmin for a database that large. Use something like Sequel Pro its free and easy to use.

Second if you dont want the tables that WPML Created and you have removed the plugin from your site you can remove the tables that it creates.

Upload the sql to a new database on your local machine and remove all this tables for each site:


I assuming your prefix is wp_(1,2,3) and so on.

share|improve this answer
Thank's, I'll try this out. – Johan Dahl Aug 16 '12 at 16:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.