Skip to content

Instantly share code, notes, and snippets.

@cdmz
Last active September 12, 2015 04:50
Show Gist options
  • Save cdmz/040f80c55b1a20cf9017 to your computer and use it in GitHub Desktop.
Save cdmz/040f80c55b1a20cf9017 to your computer and use it in GitHub Desktop.
Update siteurl wordpress SQL
UPDATE wp_options SET option_value = replace(option_value, 'http://homologa.info/sesc-bienal', 'http://localhost/bienal-danca') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://homologa.info/sesc-bienal','http://localhost/bienal-danca');
UPDATE wp_posts SET post_content = replace(post_content, 'http://homologa.info/sesc-bienal', 'http://localhost/bienal-danca');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://homologa.info/sesc-bienal', 'http://localhost/bienal-danca');
a:2:{i:0;a:20:{s:7:"term_id";i:86;s:4:"name";s:10:"Português";s:4:"slug";s:2:"pt";s:10:"term_group";s:1:"0";s:16:"term_taxonomy_id";i:86;s:8:"taxonomy";s:8:"language";s:11:"description";s:5:"pt_BR";s:6:"parent";s:1:"0";s:5:"count";i:208;s:10:"tl_term_id";i:87;s:19:"tl_term_taxonomy_id";i:87;s:8:"tl_count";i:46;s:6:"locale";R:9;s:6:"is_rtl";i:0;s:8:"flag_url";s:76:"http://homologa.info/sesc-bienal/wp-content/plugins/polylang/flags/pt_BR.png";s:4:"flag";s:864:"<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAALCAIAAAD5gJpuAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAHjSURBVHjaYmRIZkCAfwwMf2DkLzCCMyDoBwNAALEAlTVGN/5nYPj//x8Q/P3/9++/vzZa31gY/mw5z/Tn3x8g98+f37///fn99/eq2lUAAQTS8J/h/7NPz/9C5P79WRj89f9/zv//fztLvPVezPzrz+8/f3//+vtLhl8GaANAAIE1/P8PVA1U6qn7NVTqb1XVpAv/JH7/+a/848XmtpBlj39PO8gM1PP7z2+gqwACiAnoYpC9TF9nB34NVf5z4XpoZJbEjJKfWaEfL7KLlbaURKj8Opj08RfIVb+BNgAEEBPQW1L8P+b6/mb6//s/w+/+nc4F0/9P2cj65xdHc+p/QR39//9/AdHJ9A/60l8YvjIABBAT0JYH75jStv75zwCSMBY8BXTMxXv/21ezfHj9X5/3BESDy5JfBy7/ZuBnAAggkA1//vx594kpaCnLloe/smLaVT9/ff3y/+/P/w+u/+JuW7fhwS/tSayPXrOycrEyfGQACCAWoA1//oOCDIgm72fu4vy6b4LD/9/S/3///s9+S28yy+9/LEAf//kLChVgCAEEEEjD7z9/JHgkQeHwD8gUjV79O9r6CzPLv6lr1OUFwWH9Fxjcv//9BcYoA0AAMTI4ImIROUYRMf2XARkABBgA8kMvQf3q+24AAAAASUVORK5CYII=" title="Português" alt="Português" />";s:8:"home_url";s:36:"http://homologa.info/sesc-bienal/pt/";s:10:"search_url";s:36:"http://homologa.info/sesc-bienal/pt/";s:4:"host";N;s:5:"mo_id";s:3:"560";}i:1;a:20:{s:7:"term_id";i:89;s:4:"name";s:7:"English";s:4:"slug";s:2:"en";s:10:"term_group";s:1:"0";s:16:"term_taxonomy_id";i:89;s:8:"taxonomy";s:8:"language";s:11:"description";s:5:"en_US";s:6:"parent";s:1:"0";s:5:"count";i:25;s:10:"tl_term_id";i:90;s:19:"tl_term_taxonomy_id";i:90;s:8:"tl_count";i:28;s:6:"locale";R:29;s:6:"is_rtl";i:0;s:8:"flag_url";s:76:"http://homologa.info/sesc-bienal/wp-content/plugins/polylang/flags/en_US.png";s:4:"flag";s:878:"<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAALCAIAAAD5gJpuAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAHzSURBVHjaYkxOP8IAB//+Mfz7w8Dwi4HhP5CcJb/n/7evb16/APL/gRFQDiAAw3JuAgAIBEDQ/iswEERjGzBQLEru97ll0g0+3HvqMn1SpqlqGsZMsZsIe0SICA5gt5a/AGIEarCPtFh+6N/ffwxA9OvP/7//QYwff/6fZahmePeB4dNHhi+fGb59Y4zyvHHmCEAAAW3YDzQYaJJ93a+vX79aVf58//69fvEPlpIfnz59+vDhw7t37968efP3b/SXL59OnjwIEEAsDP+YgY53b2b89++/awvLn98MDi2cVxl+/vl6mituCtBghi9f/v/48e/XL86krj9XzwEEEENy8g6gu22rfn78+NGs5Ofr16+ZC58+fvyYwX8rxOxXr169fPny+fPn1//93bJlBUAAsQADZMEBxj9/GBxb2P/9+S/R8u3vzxuyaX8ZHv3j8/YGms3w8ycQARmi2eE37t4ACCDGR4/uSkrKAS35B3TT////wADOgLOBIaXIyjBlwxKAAGKRXjCB0SOEaeu+/y9fMnz4AHQxCP348R/o+l+//sMZQBNLEvif3AcIIMZbty7Ly6t9ZmXl+fXj/38GoHH/UcGfP79//BBiYHjy9+8/oUkNAAHEwt1V/vI/KBY/QSISFqM/GBg+MzB8A6PfYC5EFiDAABqgW776MP0rAAAAAElFTkSuQmCC" title="English" alt="English" />";s:8:"home_url";s:36:"http://homologa.info/sesc-bienal/en/";s:10:"search_url";s:36:"http://homologa.info/sesc-bienal/en/";s:4:"host";N;s:5:"mo_id";s:3:"561";}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment