Welcome to WebmasterWorld Guest from 54.158.29.163

Forum Moderators: rogerd & travelin cat

Message Too Old, No Replies

Database Spring Clean

     
8:14 pm on Dec 4, 2012 (gmt 0)

New User

joined:Sept 18, 2011
posts: 12
votes: 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.
12:27 am on Dec 7, 2012 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member lorax is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Mar 31, 2002
posts:7575
votes: 0


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