Latest Tweets:
First, dowload all your WP folder from your website to your WP folder on your localhost. Just for example: from blog on http://www.ducban.com to blog on http://127.0.0.1/blog.
Next, run the query below to update your siteurl from your online blog’s url to your localhost blog’s url.
UPDATE wp_options SET option_value = REPLACE(option_value, ‘http://www.ducban.com/blog’, ‘http://127.0.0.1/blog’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
Next, use the two queries below to update your post’s url and your page’s url.
UPDATE posts SET guid = REPLACE(guid, ‘http://www.ducban.com/blog’,’http://127.0.0.1/blog’);
UPDATE posts SET post_content = REPLACE(post_content, ‘http://www.ducban.com/blog’, ‘http://127.0.0.1/blog’);
If you don’t use prefix “wp_” when install your blog, you must remove the prefix “wp_” from the table name of there queries before run them. Happy backup!
Note: I found the tip here, but it’s too long. I just want to go straight to the point, that’s why I write this tip. Anyway, thanks _paDDy_ for guide me.
