Home › Blog › Wordpress

How to change hostname in wordpress

Sun, 2006/11/05 - 00:01 — dennys

If the hostname of your wordpress is changed, please update your wordpress database.

UPDATE `wp_options` SET `option_value` = 'http://192.168.1.9/wordpress' WHERE `option_id` =46 AND `blog_id` =0 AND CONVERT( `option_name` USING utf8 ) = 'home' LIMIT 1 ;

UPDATE `wp_options` SET `option_value` = 'http://192.168.1.9/wordpress' WHERE `option_id` =1 AND `blog_id` =0 AND CONVERT( `option_name` USING utf8 ) = 'siteurl' LIMIT 1 ;


Bookmark/Search this post with:
  • Delicious
  • Digg
  • Facebook
  • Google
  • Yahoo
  • Technorati
  • Hemidemi

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • Textual smileys will be replaced with graphical ones.
  • You can enable syntax highlighting of source code with the following tags: <code>. Beside the tag style "<foo>" it is also possible to use "[foo]".
  • Insert Flickr images: [flickr-photo:id=230452326,size=s] or [flickr-photoset:id=72157594262419167,size=m].
  • You may insert videos with [video:URL]

More information about formatting options