WP tricks database migration

index.md

• localhost http://localhost/mywebsite
• remote http://mywebsite.fr

Move your wordpress to localhost

Move your website parameters to new url

UPDATE wp_options
SET option_value = replace(option_value, 'http://mywebsite.fr', 'http://localhost/mywebsite')
WHERE option_name = 'home'
OR option_name = 'siteurl';

Replace urls for posts

UPDATE wp_posts
SET guid = replace(guid, 'http://mywebsite.fr', 'http://localhost/mywebsite');

Replace urls in posts content

UPDATE wp_posts
SET post_content = replace(post_content, 'http://mywebsite.fr', 'http://localhost/mywebsite');

Change url of your website

UPDATE wp_options
SET option_value = replace(option_value, 'http://mywebsite.fr', 'http://localhost/mywebsite')
WHERE option_name = 'home'
OR option_name = 'siteurl';

Change GUID's url

UPDATE wp_posts
SET guid = REPLACE (guid, 'http://mywebsite.fr', 'http://localhost/mywebsite');

Changer medias url in articles and pages

UPDATE wp_posts
SET post_content = REPLACE (post_content, 'http://mywebsite.fr', 'http://localhost/mywebsite');

Changer meta's url

UPDATE wp_postmeta
SET meta_value = REPLACE (meta_value, 'http://mywebsite.fr', 'http://localhost/mywebsite');