How can you change the order of your posts?

How to change over 2000 WordPress Posts to new category?

• So, WordPress problem here: 1) I have imported 2000 some posts to a new WordPress blog. 2) The last people weren't that bright, and have about 95 categories with loads of duplicate categories. How can I change ALL the posts to a new category called "Blog"? (For the record, I tried making Blog the default category and deleting an old category, but that actually deleted the posts as well.) I don't want to have to go 20 posts at a time and change them all over to a new category that slowly.

• Answer:

  I think the only way you can do this is to do it thru the database itself. You would have to first export the *sql file. Make sure you have a clean copy of it before you start. That's the easy part. You do this thru your cpanel, or whatever the host gives you for a control panel. Phpmyadmin is the tool. You'll then need to open the file in a text editor and first, find all instances of categories that you want to change. For instance. Posts are in category bloo. You want to change that to blog. You would do a find and replace all to replace bloo with blog. ----- Blog posts should not be deleted if you delete a category. They should all go into uncategorized, or possibly general, depending on how old the blog software is. You could also try this - make a back up of the database first! Look for the uncategorized category - or it could be something else the old people changed it to. This is the default cat. Delete all categories. All posts should go into this default category. THen, download another copy of the database. Look for the default category to make sure it's there. Then, you can change that category to blog. Make sure you have the blog category set up already. Sorry if this sounds convoluted. It would be easier than doing it 20 posts at a time.