{"id":153,"date":"2014-01-07T22:44:48","date_gmt":"2014-01-07T21:44:48","guid":{"rendered":"http:\/\/labo.sebipic.fr\/?p=153"},"modified":"2014-01-07T22:44:48","modified_gmt":"2014-01-07T21:44:48","slug":"mysql-extraire-dump-mysql-dans-des-fichiers-individuels","status":"publish","type":"post","link":"https:\/\/www.maisse-sebastien.fr\/index.php\/mysql-extraire-dump-mysql-dans-des-fichiers-individuels\/","title":{"rendered":"MYSQL : Extraire dump mysql dans des fichiers individuels"},"content":{"rendered":"<p>Suite \u00e0 l&rsquo;article d&rsquo;hier concernant <a title=\"MySQL : extraire une base d\u2019un Dump\" href=\"http:\/\/labo.sebipic.fr\/index.php\/mysql-extraire-une-base-dun-dump\/\">l&rsquo;extraction d&rsquo;une base donn\u00e9es depuis un dump MYSQL<\/a>.<\/p>\n<p>Ce soir, j&rsquo;ai fait une recherche pour faire une extraction des tables mysql contenues dans un dump mysql puis enregistrer dans un fichier individuel.<\/p>\n<p>La recherche ne fut pas tr\u00e8s longue puisque <a title=\"http:\/\/kedar.nitty-witty.com\/blog\/\" href=\"http:\/\/kedar.nitty-witty.com\/blog\/\">kedar<\/a> avait r\u00e9aliser, il y a quelques ann\u00e9es, un script qui remplissait cette fonction.<\/p>\n<p>Voici la marche \u00e0 suivre si vous souhaitez utiliser ce script.<\/p>\n<p>Tout d&rsquo;abord, on le t\u00e9l\u00e9charge :<\/p>\n<p><strong>wget http:\/\/kedar.nitty-witty.com\/blog\/wp-content\/uploads\/2010\/02\/mysqldumpsplitter.sh.txt<\/strong><\/p>\n<p>Puis on renomme le fichier comme ceci :<\/p>\n<p><strong>sudo mv mysqldumpsplitter.sh.txt mysqldumpsplitter.sh<\/strong><\/p>\n<p>On met le droit d&rsquo;execution :<\/p>\n<p><strong>chmod +x mysqldumpsplitter.sh<\/strong><\/p>\n<p>Si on lance le script directement sans argument voici le r\u00e9sultat :<\/p>\n<p><strong>sudo .\/mysqldumpsplitter.sh<\/strong><\/p>\n<div id=\"attachment_154\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/labo.sebipic.fr\/wp-content\/uploads\/2014\/01\/mydumpsplitter.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-154\" class=\"size-medium wp-image-154\" alt=\"mydumpsplitter\" src=\"http:\/\/labo.sebipic.fr\/wp-content\/uploads\/2014\/01\/mydumpsplitter-300x14.png\" width=\"300\" height=\"14\" srcset=\"https:\/\/www.maisse-sebastien.fr\/wp-content\/uploads\/2014\/01\/mydumpsplitter-300x14.png 300w, https:\/\/www.maisse-sebastien.fr\/wp-content\/uploads\/2014\/01\/mydumpsplitter-500x24.png 500w, https:\/\/www.maisse-sebastien.fr\/wp-content\/uploads\/2014\/01\/mydumpsplitter.png 887w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-154\" class=\"wp-caption-text\">mydumpsplitter<\/p><\/div>\n<p>Dans le cas pr\u00e9sent, j&rsquo;ai lanc\u00e9 la commande ci-dessous pour extraire les diff\u00e9rentes tables du dump de la base d&rsquo;hier que j&rsquo;avais extrait du dump \u00ab\u00a0g\u00e9n\u00e9ral\u00a0\u00bb.<\/p>\n<p><strong>sudo .\/mysqldumpsplitter.sh nom-de-la-base.sql<\/strong><\/p>\n<p><span style=\"text-decoration: underline;\">R\u00e9sultat<\/span> :<\/p>\n<p>Toutes les tables de ma base de donn\u00e9es dans des fichiers individuels histoire de facilit\u00e9 la restauration de ce qui nous int\u00e9resse vraiment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Suite \u00e0 l&rsquo;article d&rsquo;hier concernant l&rsquo;extraction d&rsquo;une base donn\u00e9es depuis un dump MYSQL. Ce soir, j&rsquo;ai fait une recherche pour faire une extraction des tables mysql contenues dans un dump mysql puis enregistrer dans un fichier individuel. La recherche ne &hellip; <a href=\"https:\/\/www.maisse-sebastien.fr\/index.php\/mysql-extraire-dump-mysql-dans-des-fichiers-individuels\/\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"two_page_speed":[],"footnotes":""},"categories":[3],"tags":[22,90,91,32,89,75],"class_list":["post-153","post","type-post","status-publish","format-standard","hentry","category-informatique","tag-administration","tag-dump","tag-extraire","tag-linux","tag-mysql","tag-script"],"_links":{"self":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/comments?post=153"}],"version-history":[{"count":3,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":157,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/153\/revisions\/157"}],"wp:attachment":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/categories?post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/tags?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}