homepage Welcome to WebmasterWorld Guest from 23.23.12.202
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / WordPress
Forum Library, Charter, Moderators: lorax & rogerd

WordPress Forum

    
Database Spring Clean
2011R2d2



 
Msg#: 4525071 posted 8:14 pm on Dec 4, 2012 (gmt 0)

I plan a spring clean. Unique; possibly not.

Your opinion, please...

I'm going to take my images out of indexing, am also going to block them in robots.txt and will set header noindex,nofollow.

Relevant to this is the clean-up I plan.

(1) Over the years, as I got more clever as to how things work, I centralized upload of images to blog/images/ folder. There is, however, a number of posts that still point to varied orphan places. This I plan to clean up and also centralize.

(2) I also have a number of links I want to revert to nofollow to save rediculous link-juice loss.

My question is this:

What are the chances of exporting my posts table doing the clean-up, and importing it...to over-write the older version?

The post meta, in essence will stay the same, so there shouldn't be a problem, right?

Yeah, I know - shortcuts ;-)

I'd just hate to go the being-online-forever-while-fixing in phpmyadmin.

There's only 70 posts, of which possibly 10% will be affected.

Eagerly awaiting interesting responses.

 

lorax

WebmasterWorld Administrator lorax us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4525071 posted 12:27 am on Dec 7, 2012 (gmt 0)

Sounds like you could do that but I'd make sure I had a backup of the original just in case.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / WordPress
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved