WordPress Mysql query updation for server

UPDATE [your_table_name] SET [your_table_field] = REPLACE([your_table_field], ‘[string_to_find]’ , ‘[string_to_be_replaced]’);


UPDATE wp_posts SET guid = REPLACE( guid, ‘http://localhost/yourproject’,’http://yourdomain.com’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ”http://localhost/yourproject’, ”http://yourdomain.com’ ) ;
UPDATE wp_options SET option_value = REPLACE( option_value, ”http://localhost/yourproject’, ‘http://yourdomain.com’ ) ;

Share on Facebook0Tweet about this on Twitter0Share on Google+0Pin on Pinterest0Share on LinkedIn0Share on Reddit0
It's only fair to share...

Add Comment

Required fields are marked *. Your email address will not be published.