Further... you are editing a copy of he DB... so you should still ahvea safe copy incase you make a little error here or there?
Thats somethig I love... in less than 1 minute I can ruin and entire site... and in two more I can have it back up and running!
Same here - 'tis a strange magick, and you described what I am doing very well.
In the table `wp_posts` the text of each post is stored, with bits before and after that say something like this for the URI http://mysite.com/perma/link/pagename
, with the title of "PageTitle" and the file name of "pagename"
INSERT INTO `wp_posts` VALUES (12, 1, '2007-09-22 03:41:56', '2007-09-22 07:41:56', 'This is the first text of the post. Here is a link <a href="http://mysite.com/something/">to mysitee</a>.\r\n\r\nHere is another paragraph.\r\n\r\n<h3>What/s My Line?</h3>Another line or two here ends this post.', 'PageTitle', 0, '', 'publish', 'open', 'closed', '', 'pagename', '', '', '2007-10-08 07:29:00', '2007-10-08 11:29:00', '', 0, 'http://mysite.com/perma/link/pagename', 20, 'page', '', 0);
What's making me nervous is the possibility of blythly replacing a few instances of http://mysite.com/perma/link/pagename
because they happen to match the link I need to change within the post. And, that led me to wonder what would happen if I accidentally clip something and create some other inconsistency or other in the information before and after the post content. Accidents happen!
Because I'm being careful and going link by link, I think I'm OK, for my current needs, but it'd be a good thing to learn enough to be confident about detecting and fixing accidents.
I don't mind messing around with small parts without knowing how the whole thing works, but I do insist on knowing I'm not doing harm. It's sort of like knowing to keep oil in a car and being aware of when an engine sounds/smells like the crank case is dry, without knowing how to rebuild an engine myself. Anyone who drives a car that burns oil should know how problems sound and smell, as well as know checking their oil and following through, though they may get by for a while without that insight.
Edited by AbleReach, 10 October 2007 - 08:57 PM.