How do I move a Wordpress site to another server?

Question

i'm using this sql.. but it does not work

UPDATE wp_options SET option_value = replace(option_value, 'http://old.com, 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_options SET option_value = replace(option_value, 'http://old.com', 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://old.com,'http://new.com');

UPDATE wp_posts SET guid = replace(guid, 'http://old.com','http://new.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://old.com, 'http://new.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://old.com', 'http://new.com');

UPDATE wp_faquestion SET QuestionAnswer = replace(QuestionAnswer, 'http://old.com, 'http://new.com');

UPDATE wp_faquestion SET QuestionAnswer = replace(QuestionAnswer, 'http://old.com', 'http://new.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://old.com, 'http://new.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://old.com', 'http://new.com');

Answer 1

I do this all the time to move a site from our staging server to the live domain.

I use PHPMyAdmin to export the database as an SQL file, then open it up in a text editor and do a global find and replace on the old url to change it to the new url.

The use the SQL script to import the new SQL file to the new database, and copy the file across. Works like magic every time.

Answer 2

How to Export and Import a Wordpress Blog

Answer 3

http://codex.wordpress.org/Moving_WordPress