[wp-hackers] Re: Remove Excess DB Info?

[Chris Poteet]

Yes, you can use a tool like SQLyog (which I like), compare the schema
to a fresh WP install and have it chuck the extra ones.

On Nov 21, 10:39 pm, "Computer Guru" <computerg... at neosmart.net>
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.
>
> Thanks.
>
> --
> Computer Guru
> Director,
> NeoSmart Technologieshttp://neosmart.net/blog/
> _______________________________________________
> wp-hackers mailing list
> wp-hack... at lists.automattic.comhttp://lists.automattic.com/mailman/listinfo/wp-hackers