{"id":6495,"date":"2016-07-26T18:17:24","date_gmt":"2016-07-26T16:17:24","guid":{"rendered":"http:\/\/www.beseit.net\/?p=6495"},"modified":"2018-03-22T14:46:21","modified_gmt":"2018-03-22T12:46:21","slug":"update-old-url-to-new-url-in-wordpress-mysql-query","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=6495","title":{"rendered":"Movent WordPress: de servidor, canviant el nom de la carpeta \u2026"},"content":{"rendered":"

MOVENT DE SERVIDOR PER\u00d2 MANTENINT NOMS DE CARPETES<\/strong><\/p>\n

UPDATE wp_1options SET option_value = replace(option_value, ‘http:\/\/192.168.1.40\/beseit’ , ‘http:\/\/www.beseit.net’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’<\/p>\n

UPDATE wp_1posts SET guid = replace(guid, ‘http:\/\/192.168.1.40\/beseit’ , ‘http:\/\/www.beseit.net’)<\/p>\n

UPDATE wp_1posts SET post_content = replace(post_content, ‘http:\/\/192.168.1.40\/beseit’ , ‘http:\/\/www.beseit.net’)<\/p>\n

UPDATE wp_1postmeta SET meta_value = replace(meta_value, ‘http:\/\/192.168.1.40\/beseit’ , ‘http:\/\/www.beseit.net’)
\n————— —————–
\nUPDATE wp_1options SET option_value = replace(option_value, ‘http:\/\/www.beseit.net’ , ‘http:\/\/192.168.1.40\/beseit’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’<\/p>\n

UPDATE wp_1posts SET guid = replace(guid, ‘http:\/\/www.beseit.net’ , ‘http:\/\/192.168.1.40\/beseit’)<\/p>\n

UPDATE wp_1posts SET post_content = replace(post_content, ‘http:\/\/www.beseit.net’ , ‘http:\/\/192.168.1.40\/beseit’)<\/p>\n

UPDATE wp_1postmeta SET meta_value = replace(meta_value, ‘http:\/\/www.beseit.net’, ‘http:\/\/192.168.1.40\/beseit’)
\n————— —————–<\/p>\n

UPDATE wp_1options SET option_value = replace(option_value, ‘http:\/\/www.beseit.net’, ‘http:\/\/192.168.1.40\/beseit’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;<\/p>\n

UPDATE wp_1posts SET guid = replace(guid, ‘http:\/\/www.beseit.net’, ‘http:\/\/192.168.1.40\/beseit’);<\/p>\n

UPDATE wp_1posts SET post_content = replace(post_content, ‘http:\/\/www.beseit.net’, ‘http:\/\/192.168.1.40\/beseit’);<\/p>\n

UPDATE wp_1postmeta SET meta_value = replace(meta_value, ‘http:\/\/www.beseit.net’, ‘http:\/\/192.168.1.40\/beseit’);<\/p>\n

————— —————–
\nurquizu local-> justhost
\nUPDATE wp_1options SET option_value = replace(option_value, ‘http:\/\/192.168.1.40\/urquizu’, ‘http:\/\/www.urquizu.info’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;# MySQL ha retornat un conjunt buit (p.e. cap fila).<\/p>\n

UPDATE wp_1posts SET guid = replace(guid, ‘http:\/\/192.168.1.40\/urquizu’, ‘http:\/\/www.urquizu.info’);# 47 files afectades.<\/p>\n

UPDATE wp_1posts SET post_content = replace(post_content, ‘http:\/\/192.168.1.40\/urquizu’, ‘http:\/\/www.urquizu.info’);# MySQL ha retornat un conjunt buit (p.e. cap fila).<\/p>\n

UPDATE wp_1postmeta SET meta_value = replace(meta_value, ‘http:\/\/192.168.1.40\/urquizu’, ‘http:\/\/www.urquizu.info’);# MySQL ha retornat un conjunt buit (p.e. cap fila).<\/p>\n

Moving Directories On Your Existing Server<\/span><\/h2>\n

He tingut necessitat de canviar el nom de la carpeta que contenia la web\u00a0http:\/\/192.168.1.40\/english —-> http:\/\/192.168.1.40\/english_note\/<\/p>\n

Aquest canvi \u00e9s m\u00e9s complexe del que sembla a primera vista. Ja que per exemple hi ha post que apunten a english\/upload …<\/p>\n

He partit del sup\u00f2sit que si a la bd MySQL canvio tots els registres que contenen english a english_note, la cosa hauria de funcionar. He fet la prova i sembla que ha funcionat. Si surt algun inconvenient ja ho anotar\u00e9. De moment va b\u00e9.<\/p>\n

Les taules que contenen \/english\/ s\u00f3n :<\/p>\n