Skip to content

Instantly share code, notes, and snippets.

@marlonassuncao

marlonassuncao/update_wordpress.sql

Last active September 19, 2019 20:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marlonassuncao/16a2ed2d79699939dbef to your computer and use it in GitHub Desktop.
Save marlonassuncao/16a2ed2d79699939dbef to your computer and use it in GitHub Desktop.
Download ZIP
Update tables for wordpress.
Raw
update_wordpress.sql
UPDATE wp_options SET option_value = replace(option_value, '', '') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, '', '');
UPDATE wp_posts SET post_content = replace(post_content, '', '');
UPDATE wp_postmeta SET meta_value = replace(meta_value, '', '');
UPDATE wp_revslider_sliders SET params = REPLACE(params, 'https:\\/\\/vps02.nawe.com.br\\/tests\\/preall\\/', 'https:\\/\\/www.preall.com.br\\/');
UPDATE wp_revslider_slides SET layers = REPLACE(layers, 'https:\\/\\/vps02.nawe.com.br\\/tests\\/preall\\/', 'https:\\/\\/www.preall.com.br\\/');
UPDATE wp_revslider_slides SET params = REPLACE(params, 'https:\\/\\/vps02.nawe.com.br\\/tests\\/preall\\/', 'https:\\/\\/www.preall.com.br\\/');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment