{"id":149,"date":"2004-07-03T17:29:51","date_gmt":"2004-07-03T15:29:51","guid":{"rendered":"http:\/\/www.marblestation.com\/blog\/?p=149"},"modified":"2012-04-26T19:06:38","modified_gmt":"2012-04-26T17:06:38","slug":"drupal-de-gpl-tarragona-en-utf-8","status":"publish","type":"post","link":"https:\/\/www.marblestation.com\/?p=149","title":{"rendered":"Drupal de GPL Tarragona migrado a UTF-8"},"content":{"rendered":"<p>Siguiendo el consejo de Steven Wittens que indico en la actualizaci\u00f3n de un <a href=\"http:\/\/www.marblestation.com\/blog\/index.php?p=147\">post anterior<\/a>, hemos migrado todo el drupal de <a href=\"http:\/\/www.gpltarragona.org\">GPL Tarragona<\/a> a UTF-8. Nos ha <a href=\"http:\/\/jhernandez.gpltarragona.org\/blog\/archives\/000120.html\">sorprendido muchisimo<\/a> lo sencillo que ha resultado, estos han sido los pasos:<\/p>\n<ol>\n<li> Volcamos la base de datos de drupal de MySQL a un fichero:\n<pre>\r\n$ mysqldump -p -u root drupal > drupal.sql\r\n<\/pre>\n<\/li>\n<li> Como la base de datos estaba en ISO-8859-1, la convertimos a UTF-8 utilizando el comando iconv:\n<pre>\r\n$ iconv -f ISO-8859-15 -t UTF-8 -o drupal.utf.sql drupal.sql\r\n<\/pre>\n<\/li>\n<li> A continuaci\u00f3n borramos la base de datos de MySQL para eliminar todas las tablas y sus datos, y la volvemos a crear:\n<pre>\r\n$ mysql -p -u root\r\nmysql> drop database drupal;\r\nQuery OK, 0 rows affected (0.32 sec)\r\n\r\nmysql> create database drupal;\r\nQuery OK, 1 row affected (0.00 sec)\r\n<\/pre>\n<\/li>\n<li> Ahora es el momento de introducir los datos convertidos a UTF que tenemos en el archivo drupal.utf.sql generado por iconv:\n<pre>\r\n$ mysql -p -u root drupal &#60; drupal.utf.sql\r\n<\/pre>\n<\/li>\n<\/ol>\n<p>En este punto ya tenemos los datos de la base de datos migrados, ahora solo falta deshacer los cambios que hice segun cuento en este <a href=\"http:\/\/www.marblestation.com\/blog\/index.php?p=147\">post<\/a>, solo falta indicar en el .htaccess:<\/p>\n<pre>\r\nAddDefaultCharset UTF-8\r\n<\/pre>\n<p>Y todo listo, ya tenemos drupal completamente migrado a UTF-8.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Siguiendo el consejo de Steven Wittens que indico en la actualizaci\u00f3n de un post anterior, hemos migrado todo el drupal de GPL Tarragona a UTF-8. Nos ha sorprendido muchisimo lo sencillo que ha resultado, estos han sido los pasos: Volcamos la base de datos de drupal de MySQL a un fichero: $ mysqldump -p -u &hellip; <a href=\"https:\/\/www.marblestation.com\/?p=149\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Drupal de GPL Tarragona migrado a UTF-8<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,6],"tags":[],"class_list":["post-149","post","type-post","status-publish","format-standard","hentry","category-espanyol","category-tecnologia"],"_links":{"self":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=149"}],"version-history":[{"count":1,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/149\/revisions"}],"predecessor-version":[{"id":1771,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/149\/revisions\/1771"}],"wp:attachment":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}