Advanced Search

Return to Snippet

Revision: 20640
at August 19, 2011 10:10 by beneberle
Updated Code 
UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');

UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'http://localhost:8888/', 'http://www.new-domain.com');

UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');

Revision: 20639
at April 29, 2011 03:02 by beneberle
Updated Code 
UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');

UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');

Revision: 20638
at April 29, 2011 03:00 by beneberle
Updated Code 
UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');

UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');


UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');

Revision: 20637
at November 20, 2009 11:34 by beneberle
Initial Code 
UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');

UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Wordpress: Local To Remote Procedures

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, wordpress

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL