[wp-hackers] Site Address during development

[Muro, Matthew]

There is a Codex page that describes how to change your URL:  http://codex.wordpress.org/Changing_The_Site_URL

Simply update the post_content and the guid to whatever new URL you want.


UPDATE wp_posts SET guid = REPLACE (
guid,
'http://exampleoldsiteurl.com',
'http://examplenewsiteurl.com');

UPDATE wp_posts SET post_content = REPLACE (
post_content,
'http://exampleoldsiteurl.com',
'http://examplenewsiteurl.com');

Matthew Muro
Web Developer
UA Office of Web Communications
205-348-0304







Date: Thu, 2 Sep 2010 08:36:17 -0400
From: Michael Clark
       <dc153464a11bcf5aeb18180db28017fb.wp-hackers at planetmike.com<mailto:dc153464a11bcf5aeb18180db28017fb.wp-hackers at planetmike.com>>
Subject: [wp-hackers] Site Address during development
To: wp-hackers at lists.automattic.com<mailto:wp-hackers at lists.automattic.com>
Message-ID: <p06240802c8a548196052@[192.168.1.65]>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

Good morning,

I'm developing a site for a client, and they are finally able to
start adding their info, posts and pages, both with a lot of photos.
I have the WordPress address (URL) and Site address (URL) (set under
http://www.example.com/wp-admin/options-general.php ) defined to be
the temporary subdomain of their domain name. But when they embed
photos or PDFs into a post or page, the temporary domain name is
embedded into the post. Once we go live this weekend is there an easy
way to change those details into the new, permanent domain name? I
don't want to have to maintain the development URL forever.

Actually, it seems silly to embed the domain name into the posts and
pages at all. It's adding a bit to the page, plus possible delaying
the loading of pages by fractions of a second as the page requests
have to hit DNS. Shouldn't everything embedded be relative to the
root directory of WordPress? Thanks, Mike



--

Michael Clark
http://www.PlanetMike.com

"Injustice anywhere is a threat to justice everywhere."
 - Martin Luther King Jr.