{"id":20037,"date":"2026-11-18T18:44:28","date_gmt":"2026-11-18T16:44:28","guid":{"rendered":"https:\/\/www.beseit.net\/?p=20037"},"modified":"2026-11-20T11:38:30","modified_gmt":"2026-11-20T09:38:30","slug":"com-carregar-una-bd-de-deepin-al-mariadb-del-synology","status":"publish","type":"post","link":"http:\/\/www.beseit.net\/?p=20037","title":{"rendered":"\u2b50\u2b50\u2b50 Com carregar una BD de Deepin al MariaDB del Synology"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Com carregar una BD de Deepin al MariaDB del Synology<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Objectiu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Traspassar una c\u00f2pia de seguretat d&#8217;una base de dades MariaDB del Deepin al servidor MariaDB del Synology, sense utilitzar phpMyAdmin per importar el fitxer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En el nostre cas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ordinador d&#8217;origen:<\/strong> Deepin Linux.<\/li>\n\n\n\n<li><strong>Servidor de destinaci\u00f3:<\/strong> Synology principal (<code>synology_vall<\/code>).<\/li>\n\n\n\n<li><strong>IP del Synology:<\/strong> <code>192.168.1.41<\/code>.<\/li>\n\n\n\n<li><strong>Port MariaDB:<\/strong> <code>3307<\/code>.<\/li>\n\n\n\n<li><strong>Usuari MariaDB:<\/strong> <code>urqtejmi<\/code>.<\/li>\n\n\n\n<li><strong>Base de dades de destinaci\u00f3:<\/strong> <code>youtube<\/code>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. Preparar el fitxer SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El fitxer de c\u00f2pia de seguretat es troba a:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/home\/Miquel\/Downloads\/dump.sql<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Comprovar que existeix i veure&#8217;n la mida:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ls -lh \/home\/Miquel\/Downloads\/dump.sql<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2. Comprovar el servidor Synology<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Connectar-se al Synology mitjan\u00e7ant SSH:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ssh urqtejmi@192.168.1.41<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Comprovar que MariaDB escolta al port 3307:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">netstat -lnt | grep 3307<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Resultat esperat:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">tcp  0  0  0.0.0.0:3307  0.0.0.0:*  LISTEN<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sortir de la connexi\u00f3 SSH:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">exit<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3. Importar la base de dades des del Deepin<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Aquesta \u00e9s la comanda important!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Obrir el terminal del Deepin i executar:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mariadb --skip-ssl -h 192.168.1.41 -P 3307 -u urqtejmi -p youtube &lt; \"\/home\/Miquel\/Downloads\/dump.sql\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">El sistema demanar\u00e0 la contrasenya de MariaDB.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Introduir-la i pr\u00e9mer Enter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Per qu\u00e8 utilitzem<\/strong> <code><strong>--skip-ssl<\/strong><\/code><strong>?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El client MariaDB del Deepin exigia una connexi\u00f3 SSL, per\u00f2 el servidor MariaDB del Synology no l&#8217;admetia. Amb aquesta opci\u00f3 permetem la connexi\u00f3 sense SSL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Comprovar que la importaci\u00f3 ha funcionat<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Executar des del Deepin:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mariadb --skip-ssl -h 192.168.1.41 -P 3307 -u urqtejmi -p -e \"SHOW TABLES FROM youtube;\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Introduir la contrasenya.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si apareix el llistat de les taules de <code>youtube<\/code>, la importaci\u00f3 ha estat correcta.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tamb\u00e9 podem comprovar-ho entrant a phpMyAdmin del Synology i seleccionant la base de dades <code>youtube<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5. Resum de la comanda<\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#f00505\" class=\"has-inline-color\">Per a futures importacions, nom\u00e9s cal recordar:<\/mark><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code><strong>mariadb --skip-ssl -h 192.168.1.41 -P 3307 -u urqtejmi -p youtube &lt; \"\/home\/Miquel\/Downloads\/youtube.sql\"<\/strong><\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mariadb --skip-ssl -h 192.168.1.41 -P 3307 -u urqtejmi -p NOM_BASE_DADES &lt; \"\/ruta\/al\/fitxer.sql\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Cal substituir:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>NOM_BASE_DADES<\/code> pel nom de la base de dades de destinaci\u00f3.<\/li>\n\n\n\n<li>La ruta pel fitxer SQL que volem importar.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Important:<\/strong> aquesta connexi\u00f3 no utilitza xifratge SSL. Cal fer-la en una xarxa local de confian\u00e7a. Tamb\u00e9 conv\u00e9 tenir una c\u00f2pia de seguretat de la base de dades de destinaci\u00f3 abans d&#8217;importar, especialment si ja cont\u00e9 informaci\u00f3.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Resultat:<\/strong> importaci\u00f3 de <code>dump.sql<\/code> a la base de dades <code>youtube<\/code> del Synology realitzada correctament des del terminal del Deepin, sense necessitat d&#8217;utilitzar la funci\u00f3 d&#8217;importaci\u00f3 de phpMyAdmin.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">sentencia SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>--<mark style=\"background-color:rgba(0, 0, 0, 0);color:#fa1414\" class=\"has-inline-color\"> quantes es repeteixen i quantes s\u00f3n noves<\/mark>\nSELECT\n  SUM(EXISTS (SELECT 1 FROM llistes l WHERE l.nom_llista = r.nom_llista)) AS repetides,\n  SUM(NOT EXISTS (SELECT 1 FROM llistes l WHERE l.nom_llista = r.nom_llista)) AS noves\nFROM llistes_recarrega r;<\/strong><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">La carrega<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO llistes (nom_llista, num_videos, data_entrada)\nSELECT r.nom_llista, r.num_videos, r.data_entrada\nFROM llistes_recarrega r\nJOIN (SELECT MAX(id) AS id FROM llistes_recarrega GROUP BY nom_llista) m\n  ON m.id = r.id\nWHERE NOT EXISTS (SELECT 1 FROM llistes l WHERE l.nom_llista = r.nom_llista)\nORDER BY r.id;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Com carregar una BD de Deepin al MariaDB del Synology Objectiu Traspassar una c\u00f2pia de seguretat d&#8217;una base de dades MariaDB del Deepin al servidor MariaDB del Synology, sense utilitzar phpMyAdmin per importar el fitxer. En el nostre cas: 1. &hellip; <a href=\"http:\/\/www.beseit.net\/?p=20037\">Continua llegint <span class=\"meta-nav\">&rarr;<\/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-20037","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20037","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=20037"}],"version-history":[{"count":7,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20037\/revisions"}],"predecessor-version":[{"id":20049,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/20037\/revisions\/20049"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20037"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}