{"id":548,"date":"2013-05-08T17:48:59","date_gmt":"2013-05-08T16:48:59","guid":{"rendered":"http:\/\/www.netexpertise.eu\/fr\/?p=548"},"modified":"2021-08-09T07:52:22","modified_gmt":"2021-08-09T06:52:22","slug":"sauvegarde-des-procedures-stockees-mysql","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html","title":{"rendered":"Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql"},"content":{"rendered":"\n<p>Nombreux sont ceux \u00e0 utiliser l&rsquo;utilitaire mysqldump pour sauvegarder leurs bases de donn\u00e9es <a href=\"\/fr\/category\/database\/mysql\">Mysql<\/a>. Soyez vigilant parce que <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/mysqldump.html\" target=\"_blank\" rel=\"noreferrer noopener\">mysqldump<\/a> inclut les triggers mais les fonctions et proc\u00e9dures stock\u00e9es sont ignor\u00e9es.<br>Les fonctions et proc\u00e9dures stock\u00e9es sont regroup\u00e9es sous le nom routines dans Mysql. Ex\u00e9cutez <em>mysqldump &#8211;help<\/em> et vous verrez que la valeur par d\u00e9faut des routines est \u00e0 FALSE.<\/p>\n\n\n\n<p><br>Vous pouvez inclure fonctions et proc\u00e9dures stock\u00e9es en ajoutant l&rsquo;option <em>&#8211;routines<\/em> lors de vos sauvegardes:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">mysqldump -u user -p my_database --routines backup.sql<\/code><\/pre>\n\n\n\n<p>\u00a0<br>Mieux, si vous ne voulez pas taper l&rsquo;option &#8211; ou \u00e9viter de l&rsquo;oublier &#8211; \u00e0 chaque fois que vous lancer une backup, le comportement par d\u00e9faut de Mysqldump peut \u00eatre chang\u00e9 en ajoutant une section mysqldump dans le fichier my.cnf, dans votre r\u00e9pertoire maison la plupart du temps.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ cat ~\/.my.cnf\n[mysqldump]\nroutines = true<\/code><\/pre>\n\n\n\n<p><br><br>Enfin, assurez-vous que le nouveau comportement a bien \u00e9t\u00e9 pris en compte<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqldump --print-defaults \nmysqldump would have been started with the following arguments:\n--routines=true<\/code><\/pre>\n\n\n\n<p><br>V\u00e9rifiez vos scripts de backup avant d&rsquo;avoir recours \u00e0 un plan de reprise d&rsquo;activit\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nombreux sont ceux \u00e0 utiliser l&rsquo;utilitaire mysqldump pour sauvegarder leurs bases de donn\u00e9es Mysql. Soyez vigilant parce que mysqldump inclut les triggers mais les fonctions et proc\u00e9dures stock\u00e9es sont ignor\u00e9es.Les fonctions et proc\u00e9dures stock\u00e9es sont regroup\u00e9es sous le nom routines dans Mysql. Ex\u00e9cutez mysqldump &#8211;help et vous verrez que la valeur par d\u00e9faut des routines [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[4],"tags":[404,381,133],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql<\/title>\n<meta name=\"description\" content=\"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql\" \/>\n<meta property=\"og:description\" content=\"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-08T16:48:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T06:52:22+00:00\" \/>\n<meta name=\"author\" content=\"dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@netexpertise\" \/>\n<meta name=\"twitter:site\" content=\"@netexpertise\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html\",\"name\":\"Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql\",\"isPartOf\":{\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#website\"},\"datePublished\":\"2013-05-08T16:48:59+00:00\",\"dateModified\":\"2021-08-09T06:52:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\"},\"description\":\"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes\",\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.netexpertise.eu\/fr\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#website\",\"url\":\"https:\/\/www.netexpertise.eu\/fr\/\",\"name\":\"Netexpertise\",\"description\":\"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"caption\":\"dave\"},\"sameAs\":[\"http:\/\/www.netexpertise.eu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql","description":"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html","og_locale":"fr_FR","og_type":"article","og_title":"Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql","og_description":"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes","og_url":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html","og_site_name":"Netexpertise","article_published_time":"2013-05-08T16:48:59+00:00","article_modified_time":"2021-08-09T06:52:22+00:00","author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html","url":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html","name":"Netexpertise - Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql","isPartOf":{"@id":"https:\/\/www.netexpertise.eu\/fr\/#website"},"datePublished":"2013-05-08T16:48:59+00:00","dateModified":"2021-08-09T06:52:22+00:00","author":{"@id":"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632"},"description":"Mysqldump ignore les fonctions et proc\u00e9dures stock\u00e9es parr d\u00e9faut. Voici comment les inclure dans vos sauvegardes quotidiennes","breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/fr\/database\/mysql\/sauvegarde-des-procedures-stockees-mysql.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.netexpertise.eu\/fr"},{"@type":"ListItem","position":2,"name":"Sauvegarde des Proc\u00e9dures Stock\u00e9es Mysql"}]},{"@type":"WebSite","@id":"https:\/\/www.netexpertise.eu\/fr\/#website","url":"https:\/\/www.netexpertise.eu\/fr\/","name":"Netexpertise","description":"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632","name":"dave","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","caption":"dave"},"sameAs":["http:\/\/www.netexpertise.eu"]}]}},"_links":{"self":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/548"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/comments?post=548"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/548\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/media?parent=548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/categories?post=548"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/tags?post=548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}