{"id":2336,"date":"2016-11-29T20:21:40","date_gmt":"2016-11-29T19:21:40","guid":{"rendered":"http:\/\/www.jmarior.net\/itank\/?p=2336"},"modified":"2016-11-29T20:21:40","modified_gmt":"2016-11-29T19:21:40","slug":"migrar-wordpress-de-dominio-y-cambiar-las-referencias-al-dominio-antiguo-mediante-sql","status":"publish","type":"post","link":"https:\/\/www.jmarior.net\/itank\/migrar-wordpress-de-dominio-y-cambiar-las-referencias-al-dominio-antiguo-mediante-sql\/","title":{"rendered":"Migrar WordPress de dominio y cambiar las referencias al dominio antiguo mediante SQL"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2337\" src=\"https:\/\/www.jmarior.net\/itank\/files\/wordpress-migration.jpg\" alt=\"wordpress-migration\" width=\"600\" height=\"235\" srcset=\"https:\/\/www.jmarior.net\/itank\/files\/wordpress-migration.jpg 600w, https:\/\/www.jmarior.net\/itank\/files\/wordpress-migration-400x157.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><br \/>\nSi has migrado tu wordpress de dominio y tienes montones de posts con referencias URL a la antiguo dominio, puedes cambiarlas todas de un plumazo mediante una \u00fanica sentencoa SQL y voil\u00e1&#8230;<\/p>\n<pre>UPDATE wp_posts\r\n SET post_content = REPLACE(post_content, 'http:\/\/www.olddomain.net', 'http:\/\/www.newdomain.net')<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Si has migrado tu wordpress de dominio y tienes montones de posts con referencias URL a la antiguo dominio, puedes cambiarlas todas de un plumazo mediante una \u00fanica sentencoa SQL y voil\u00e1&#8230; UPDATE wp_posts SET post_content = REPLACE(post_content, &#8216;http:\/\/www.olddomain.net&#8217;, &#8216;http:\/\/www.newdomain.net&#8217;)<\/p>\n","protected":false},"author":2,"featured_media":2337,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[51,55,21],"class_list":["post-2336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itank-ideas","tag-hacks","tag-mysql","tag-wordpress"],"views":923,"_links":{"self":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts\/2336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/comments?post=2336"}],"version-history":[{"count":0,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts\/2336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/media\/2337"}],"wp:attachment":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/media?parent=2336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/categories?post=2336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/tags?post=2336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}