{"id":147,"date":"2014-01-06T21:48:50","date_gmt":"2014-01-06T20:48:50","guid":{"rendered":"http:\/\/labo.sebipic.fr\/?p=147"},"modified":"2014-01-06T21:48:50","modified_gmt":"2014-01-06T20:48:50","slug":"mysql-extraire-une-base-dun-dump","status":"publish","type":"post","link":"https:\/\/www.maisse-sebastien.fr\/index.php\/mysql-extraire-une-base-dun-dump\/","title":{"rendered":"MySQL : extraire une base d&rsquo;un Dump"},"content":{"rendered":"<p>Si vous souhaitez extraire une <strong>base de donn\u00e9es<\/strong> d&rsquo;un DUMP MySQL, rien de plus simple.<\/p>\n<p><strong>sed -n &lsquo;\/^&#8211; Current Database: `nom-de-la-base`\/,\/^&#8211; Current Database: `\/p&rsquo; dump-mysql.sql &gt; nom-de-la-base.sql<\/strong><\/p>\n<p>Si vous souhaitez faire une restauration d&rsquo;une base de donn\u00e9es depuis un Dump MySQL sur un serveur :<\/p>\n<p><strong>mysql&gt; mysql -u root -p &#8211;one-database nom-de-la-base &lt; dump-mysql.sql<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si vous souhaitez extraire une base de donn\u00e9es d&rsquo;un DUMP MySQL, rien de plus simple. sed -n &lsquo;\/^&#8211; Current Database: `nom-de-la-base`\/,\/^&#8211; Current Database: `\/p&rsquo; dump-mysql.sql &gt; nom-de-la-base.sql Si vous souhaitez faire une restauration d&rsquo;une base de donn\u00e9es depuis un Dump &hellip; <a href=\"https:\/\/www.maisse-sebastien.fr\/index.php\/mysql-extraire-une-base-dun-dump\/\">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,7,32,89],"class_list":["post-147","post","type-post","status-publish","format-standard","hentry","category-informatique","tag-administration","tag-dump","tag-extraire","tag-informatique-2","tag-linux","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/147","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=147"}],"version-history":[{"count":5,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/147\/revisions"}],"predecessor-version":[{"id":152,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/147\/revisions\/152"}],"wp:attachment":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/categories?post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/tags?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}