freestyle developments

site menu

  • Jump to page content
  • home
  • blog
  • about
  • projects
  • contact

Posts Tagged ‘wordpress’

Migrating WordPress to a new URL

Tuesday, July 6th, 2010

WordPress is a nonsense, and stores it’s URL in multiple places in the database. If you want to move your WordPress install to a different host, exec the following MySQL commands to change the URL in all instances:

UPDATE wp_options
   SET option_value = REPLACE(option_value, "[Old site URL]", "[New site URL]")
 WHERE option_value LIKE "%[Old site URL]%";

 UPDATE wp_posts
   SET post_content = REPLACE(post_content, "[Old site URL]", "[New site URL]")
 WHERE post_content LIKE "%[Old site URL]%";

  UPDATE wp_posts
   SET guid = REPLACE(guid, "[Old site URL]", "[New site URL]")
 WHERE guid LIKE "%[Old site URL]%";

Replace [Old site URL] and [New site URL] appropriately

Tags: database, mysql, url, wordpress
Posted in Blog, SQL | No Comments »


archives

  • July 2010
  • May 2010
  • February 2010
  • January 2010
  • December 2009
  • December 2008
  • October 2008
  • August 2008
  • May 2008

categories

  • Blog (1)
  • Grinds My Gears (5)
  • Hosting (2)
  • JavaScript (1)
  • PHP (1)
  • Sports (1)
  • SQL (1)

meta

  • Entries RSS Entries
  • Entries RSS Comments
  • powered by WordPress

footer menu

  • valid xhtml & css
  • accessibility information
  • © 2010 freestyle developments
  • design by element-media