{"id":16322,"date":"2025-06-13T13:42:22","date_gmt":"2025-06-13T11:42:22","guid":{"rendered":"https:\/\/www.beseit.net\/?p=16322"},"modified":"2025-06-14T12:35:50","modified_gmt":"2025-06-14T10:35:50","slug":"migrar-un-blog-wordpress","status":"publish","type":"post","link":"http:\/\/www.beseit.net\/?p=16322","title":{"rendered":"Migrar un blog WordPress"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">? <strong>Migrar un blog WordPress<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">?\ufe0f De: <code>http:\/\/192.168.1.41\/english_note<\/code><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">\u27a1\ufe0f A: <code>http:\/\/192.168.1.49\/english_note<\/code><\/h3>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 1. <strong>Copiar els fitxers del lloc web<\/strong><\/h3>\n\n\n\n<p>Des de Windows (si tens unitats de xarxa muntades):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">plaintextCopiaModifica<code>Copiar:    S:\\english_note\\\nEnganxar:  O:\\english_note\\\n<\/code><\/pre>\n\n\n\n<p>Tamb\u00e9 es pot fer amb <code>rsync<\/code>, <code>scp<\/code> o FTP si \u00e9s necessari.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 2. <strong>Exportar la base de dades<\/strong><\/h3>\n\n\n\n<p>Des de <strong>phpMyAdmin<\/strong> al servidor <code>192.168.1.41<\/code>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Entra a la base de dades de <code>english_note<\/code><\/li>\n\n\n\n<li>Ves a la pestanya <strong>Exportar<\/strong><\/li>\n\n\n\n<li>Format: <code>SQL<\/code><\/li>\n\n\n\n<li>Desa el fitxer <code>.sql<\/code> (ex: <code>english_note.sql<\/code>)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 3. <strong>Importar la base de dades al nou servidor<\/strong><\/h3>\n\n\n\n<p>Des de <strong>phpMyAdmin<\/strong> al servidor <code>192.168.1.49<\/code>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Crea una base de dades nova (ex: <code>english_note<\/code>)<\/li>\n\n\n\n<li>Importa el fitxer <code>english_note.sql<\/code><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 4. <strong>Crear un nou usuari de MySQL (opcional per\u00f2 recomanat)<\/strong><\/h3>\n\n\n\n<p>Des de phpMyAdmin o terminal MySQL:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlCopiaModifica<code>CREATE USER 'miquel'@'localhost' IDENTIFIED BY 'una_contrasenya_forta';\nGRANT ALL PRIVILEGES ON english_note.* TO 'miquel'@'localhost';\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 5. <strong>Editar el fitxer <code>wp-config.php<\/code><\/strong><\/h3>\n\n\n\n<p>Actualitza els valors seg\u00fcents al directori <code>english_note<\/code> del nou servidor (<code>O:\\english_note\\wp-config.php<\/code>):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">phpCopiaModifica<code>define('DB_NAME', 'english_note');\ndefine('DB_USER', 'miquel');\ndefine('DB_PASSWORD', 'una_contrasenya_forta');\ndefine('DB_HOST', 'localhost');\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 6. <strong>Actualitzar les URLs dins la base de dades<\/strong><\/h3>\n\n\n\n<p>Des de phpMyAdmin del <strong>nou servidor<\/strong> (<code>192.168.1.49<\/code>), a la pestanya SQL, executa:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlCopiaModifica<code>UPDATE wp_options \nSET option_value = REPLACE(option_value, 'http:\/\/192.168.1.41\/english_note', 'http:\/\/192.168.1.49\/english_note') \nWHERE option_name IN ('siteurl', 'home');\n\nUPDATE wp_posts \nSET guid = REPLACE(guid, 'http:\/\/192.168.1.41\/english_note', 'http:\/\/192.168.1.49\/english_note');\n\nUPDATE wp_posts \nSET post_content = REPLACE(post_content, 'http:\/\/192.168.1.41\/english_note', 'http:\/\/192.168.1.49\/english_note');\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Alternativa<\/strong> provada exitosament.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 <strong>Opci\u00f3 2: amb un editor com <mark style=\"background-color:rgba(0, 0, 0, 0);color:#f20909\" class=\"has-inline-color\">010 editor<\/mark>,  VS Code, Sublime o Notepad++<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Obre <code>beseit.sql<\/code>.<\/li>\n\n\n\n<li>Cerca <code>\/\/www.beseit.net<\/code>.<\/li>\n\n\n\n<li>Reempla\u00e7a per <code>\/\/192.168.1.49\/beseit<\/code>.<\/li>\n\n\n\n<li>Desa el fitxer.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"900\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2025\/06\/image-7.png\" alt=\"\" class=\"wp-image-16333\" srcset=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2025\/06\/image-7.png 727w, http:\/\/www.beseit.net\/wp-content\/uploads\/2025\/06\/image-7-242x300.png 242w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 7. <strong>Comprovar que tot funciona<\/strong><\/h3>\n\n\n\n<p>Accedeix a:<br><strong><a class=\"\" href=\"http:\/\/192.168.1.49\/english_note\/\">http:\/\/192.168.1.49\/english_note\/<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Comprova que el lloc es carrega<\/li>\n\n\n\n<li>Revisa men\u00fas, imatges i enlla\u00e7os<\/li>\n\n\n\n<li>Si cal, neteja la mem\u00f2ria cau del navegador o plugins de cach\u00e9<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">? Migraci\u00f3 completada amb \u00e8xit!<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>? Migrar un blog WordPress ?\ufe0f De: http:\/\/192.168.1.41\/english_note \u27a1\ufe0f A: http:\/\/192.168.1.49\/english_note \u2705 1. Copiar els fitxers del lloc web Des de Windows (si tens unitats de xarxa muntades): plaintextCopiaModificaCopiar: S:\\english_note\\ Enganxar: O:\\english_note\\ Tamb\u00e9 es pot fer amb rsync, scp o &hellip; <a href=\"http:\/\/www.beseit.net\/?p=16322\">Continua llegint <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":8179,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-16322","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-word-press"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16322"}],"version-history":[{"count":4,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16322\/revisions"}],"predecessor-version":[{"id":16334,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16322\/revisions\/16334"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/media\/8179"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16322"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}