[wp-hackers] Remove Excess DB Info?

[Jeremy Visser]

On Thu, 2007-11-22 at 05:39 +0200, Computer Guru wrote:
> Quick question:
> Anyone know of an easy way to drop all columns not part of the original WP
> schema from a database? Over the years I've accumulated several columns (by
> several I mean around 30-50) that shouldn't be there and wanted to know if
> there's an easier way than dropping each column one by one.

You could always do a WXR export, wipe the DB, and re-import the WXR.