[wp-hackers] need to get a list of categories from an old wp install

[Adriaan Pelzer]

If I do a "SELECT name FROM wp_terms;", I get all my categories.

Adriaan Pelzer
PIT Productions
+2712 651 2432


On Thu, Oct 15, 2009 at 10:22 PM, Sharon Chambers <sharon at brewerradio.com>wrote:

> Sorry, I know this is more of an SQL-related question, but I was wondering
> if someone could help me quickly…
>
> I’ve got an old WP-install that had way too many categories; we’ve moved it
> to another (faster) server and culled a bunch of categories in the process…
>
> Of course, I’ve got backups and all, but I need to get a list of the old
> categories now, and my SQL’s kinda rusty…
> It’s the terms/taxonomy/relationships tables I know, but if anyone could
> shoot me the mysql v5 for it, I would GREATLY appreciate it.
>
> Last resort, I suppose I could point another wp-install to that db and
> obtain that way…
>
> Many thanks!
>
> -Sharon
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>