{"id":6216,"date":"2015-11-26T17:00:18","date_gmt":"2015-11-26T15:00:18","guid":{"rendered":"http:\/\/matarranya.cat\/?p=6216"},"modified":"2023-08-10T11:05:15","modified_gmt":"2023-08-10T09:05:15","slug":"update-old-url-to-new-url-in-word-press-mysql-query","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=6216","title":{"rendered":"Update old URL to new URL in word-press mysql Query:"},"content":{"rendered":"

\u00c9s freq\u00fcent tenir la necessitat de passar el blog personal del servidor on s’allotja normalment a un servidor local o al inrev\u00e9s. \u00a0 Des de\u00a0 la secci\u00f3 par\u00e0metres general es pot\u00a0 modificar Adre\u00e7a del WordPress (URL). Per\u00f2 a m\u00e9s d’aix\u00f2 hi ha altes adresses dins de la BD de MySql que cal canvia:<\/p>\n

Es pot entrar directament a phpMyAdmin i executar el comandament SQL seg\u00fcents:<\/p>\n

[php]<\/p>\n

UPDATE wp_options SET option_value = replace(option_value, ‘http:\/\/81.0.60.37\/english_note’, ‘http:\/\/81.0.60.36\/english_note’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;<\/p>\n

UPDATE wp_posts SET post_content = replace(post_content, ‘http:\/\/213.4.33.41\/english_note’, ‘http:\/\/81.0.60.36\/english_note’) ;<\/p>\n

[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00c9s freq\u00fcent tenir la necessitat de passar el blog personal del servidor on s’allotja normalment a un servidor local o al inrev\u00e9s. \u00a0 Des de\u00a0 la secci\u00f3 par\u00e0metres general es pot\u00a0 modificar Adre\u00e7a del WordPress (URL). Per\u00f2 a m\u00e9s d’aix\u00f2 … Continua llegint →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6216","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/6216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6216"}],"version-history":[{"count":17,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/6216\/revisions"}],"predecessor-version":[{"id":13892,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/6216\/revisions\/13892"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}