Nov
18

Replace embedded post links after changing domains

Posted by Andrea under how to

And now for a short SQL lesson in a case study.

Ever do this? Map a domain to a sub-blog, post away merrily for a while (or a user does) and then one day decide you like another domain name better? Yeah. I hate when that happens. Usually because I get to fix it.

No problem! We just re-map the new domain and we’re good to go. But wait! Now all our images embedded in posts have gone *poof*. I mean, they’re still there on the server, but now we have link in posts with absolute URLs pointing to the old domain. Bummer.

Open up phpMyAdmin or whatever you use to manage your database. Click on the SQL tab because we’re gonna run a query. The query below, in fact.

update `wp_BLOGID#_posts`
set `post_content` = replace(`post_content`,’olddomain.com’,'newdomain.com’)

The above basically says in the posts table of this particular blog, change all instance of olddomain.com to newdomain.com. make sure you get the right blog ID # of the blog in question.

Share This

Leave a Reply

*
To prove you're a person (not a spam script), type the security word shown in the picture.
Anti-Spam Image



« The goodies are coming Twitaway: The Art & Science of CSS — FREE Download »
google.load("language", "1"); var curstate = 0; var hasloaded = 0; function bnc_show_translated() { if (hasloaded == 0) { bnc_lang_callback(); hasloaded = 1; } for (i = 0; i < 0; i++) { var elem = $("bnc_original_" + i); if (elem) { if (curstate) { elem.show(); } else { elem.hide(); } } } for (i = 0; i < 0; i++) { var elem = $("bnc_trans_" + i); if (elem) { if (curstate) { elem.hide(); } else { elem.show(); } } } if (curstate) { $("bnc_trans_state1").show(); $("bnc_trans_state2").hide(); curstate = 0; } else { $("bnc_trans_state1").hide(); $("bnc_trans_state2").show(); curstate = 1; } } function bnc_detect_div(div_id) { var text = document.getElementById(div_id); if (text) { text = text.innerHTML; if (text.length > 0) { google.language.detect(text, function(result) { if (!result.error) { if (result.language != "en") { if (result.confidence > 0.25) { $("bnc_translating").show(); bnc_xlate_div(result.language, div_id, "en"); } } } } ); } } } function bnc_xlate_div(src_lang,div_id,o_lang) { var text = document.getElementById(div_id); if (text) { text = text.innerHTML; google.language.translate(text, src_lang, o_lang, function(result) { var translated = document.getElementById(div_id); if (result.translation) { translated.innerHTML = result.translation; } }); } } function bnc_lang_callback() { } function bnc_startup() { bnc_xlate_div("en", "bnc_translate_info", "en"); bnc_xlate_div("en", "bnc_translate_info2", "en"); } google.setOnLoadCallback(bnc_startup);
Close
E-mail It
This blog has been fine-tuned with 13 WordPress Tweaks.