Advanced Search

Return to Snippet

Revision: 33727
at October 12, 2010 20:42 by errkk
Initial Code 
# Dev to Production

SET @uri_from = 'www.devurl.local';
SET @uri_to = 'www.liveurl.net';

UPDATE wp_options SET `option_value` = REPLACE(`option_value`, @uri_from, @uri_to) 
	WHERE `option_value` LIKE CONCAT( "%", @uri_from, "%" );

UPDATE wp_posts SET `guid` = REPLACE(`guid`, @uri_from, @uri_to);

UPDATE wp_posts SET `post_content` = REPLACE(`post_content`, @uri_from, @uri_to);

UPDATE wp_postmeta SET `meta_value` = REPLACE(`meta_value`, @uri_from, @uri_to);
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server  (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Move WordPress to another host

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, wordpress, update

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL