You are probably out of luck.
Do you have a recent backup (from a week or two or three ago) that you could use to restore, then reenter any new posts since that time?
Sometimes hosts make backups–check with them.
Resource:
WordPress Backups
I made the same mistake since I automatically assumed that the tags would be copys of, not replacements for the categories (since this was the way the “converter” of my previous tagging plugin worked, the proper meaning of “convert” is not all that obvious if one isn’t a native english speaker). But this seems easy to fix:
If you have phpMyAdmin (or similiar) installed open the table ‘wp_term_taxonomy’ and change the value of field ‘taxonomy’ from “post_tag” to “category”. As far as is can tell this is (database-wise) the only difference between tags and categories and anyway it worked for me.
I also didn’t realize the change from categories to tags was so catastrophic and that there was no going back.
After researching how to do what eikep suggests, I went into mysqladmin, pulling up the database, clicking the SQL tab at the top, and entering:
UPDATE wp_term_taxonomy SET taxonomy = replace(taxonomy,"post_tag","category");
I didn’t get the response I thought I would (~an error message) but it worked. Thanks, eikep!
Hi there,
How does this work exactly? I go to the SQL tab of wp_term_taxonomy and it says:
SELECT * FROM wp_term_taxonomy WHERE 1
If I enter anything else, there’s no “submit” button. So I can’t figure out how the UPDATE coding above is supposed to work.
Let me know.
Thanks!
websta & eikep!
Thx a lot guys, you saved my life. I almost shot my self when i discovered what I had done when converting those categories hehe
Thank you, thank you, thank you, and thank you again!
This thread just saved my life!
great thread. I did it the same way, and then found the post. http://www.bsidemix.com. Thanks again.
To add injury to insult, I didn’t know WP had destroyed my categories, so I proceeded to rename the new tags and merge them together. OMG. HELP, please!!
this was a lifesaver, thanks!!
I at first changed all the post_tag to post_category manually (having misunderstood the direction to change to just category). Now when I try to change them to just “category” manually, or use the sql script (changing the request from “post-tag” to “post_category”, I get an error message, saying “post_category” not recognized.
http://glitteringstew.com/muse
thanks for any help.
David
UPDATE from David- I had to delete the few categories I had created after they all disappeared into tags, then I was able to manually change each of 32 categories back to their original form.
I hope that little “convenient” “category to tags converter” is revamped or discarded. What a pain.
Hi all-
I too want to change my tags back to categories.
1. Will this copy them or also make my tags now go away?
2. I went to SQL taxonomy and saw this:
‘SELECT * FROM wp_term_taxonomy WHERE 1’
and pasted in this underneath it:
‘UPDATE wp_term_taxonomy SET taxonomy = replace(taxonomy,”post_tag”,”category”);’
I hit “GO” and get an error message with my sql syntax. and it didn’t fix the website categories.
This has obviously helped some of you…if anyone could please walk me through it…I’d greatly appreciate it!!!
Thanks!
LL
http://www.llworldtour.com
I really want to move to tags totally – but the official converter looks disastrous.
My expected behaviour for such a plugin
1) If a category has no corresponding tag, create the tag.
2) Add the tag to all posts which are in that category.
3) Optionally, remove the category. Default is ‘no’.
It seems that the official converter has, for point 3, the default of ‘yes’ – and it’s not an option.
For various reasons, this is undesirable!
(I’m not even sure if it does 2 – but I haven’t tested it as 3. is a showstopper for me).
Is there a way to create tags based on existing categories (without destroying those categories?)
