{"id":448,"date":"2009-02-09T11:45:19","date_gmt":"2009-02-09T10:45:19","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=448"},"modified":"2009-02-09T11:47:17","modified_gmt":"2009-02-09T10:47:17","slug":"restaurer-une-sauvegarde-en-desactivant-le-log-binaire","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2009\/02\/09\/restaurer-une-sauvegarde-en-desactivant-le-log-binaire\/","title":{"rendered":"Restaurer une sauvegarde en d\u00e9sactivant le log binaire"},"content":{"rendered":"<p>Il est pafois utile de d\u00e9sactiver le log binaire lors d&rsquo;une restauration. MySQL permet de le d\u00e9sactiver pour une session avec la commande <strong>SQL_LOG_BIN<\/strong>:<\/p>\n<address>mysql&gt; SET SESSION sql_log_bin = 0;<\/address>\n<p>Lors de la restauration avec le client mysql on peut donc utiliser la ligne de commande suivante:<\/p>\n<address>shell&gt; mysql <strong>&#8211;execute=<\/strong>\u00ab\u00a0SET SESSION sql_log_bin=0;\u00a0 <strong>SOURCE <\/strong>mon_fichier_dump.sql;\u00a0\u00bb<\/address>\n","protected":false},"excerpt":{"rendered":"<p>Il est pafois utile de d\u00e9sactiver le log binaire lors d&rsquo;une restauration. MySQL permet de le d\u00e9sactiver pour une session avec la commande SQL_LOG_BIN:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[88,8],"tags":[54,100,99,98],"class_list":["post-448","post","type-post","status-publish","format-standard","hentry","category-astuce","category-mysql","tag-mysqldump","tag-set","tag-source","tag-sql_log_bin"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-7e","jetpack-related-posts":[{"id":275,"url":"https:\/\/dasini.net\/blog\/2008\/12\/03\/les-nouveautes-de-mysql-51-part-25\/","url_meta":{"origin":448,"position":0},"title":"Les nouveaut\u00e9s de MySQL 5.1 &#8212; (part 2\/5)","author":"Olivier DASINI","date":"3 d\u00e9cembre 2008","format":false,"excerpt":"Pouvoir automatiser ses t\u00e2ches de mani\u00e8re fiable et simple est le r\u00eave de tout administrateur de base de donn\u00e9es. Le programmateur d'\u00e9v\u00e8nements (Event Scheduler) est un planificateur de t\u00e2ches (CRON-like) embarqu\u00e9 dans MySQL 5.1.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":418,"url":"https:\/\/dasini.net\/blog\/2009\/01\/16\/jai-perdu-mon-mot-de-passe-root\/","url_meta":{"origin":448,"position":1},"title":"Aie! J&rsquo;ai perdu mon mot de passe root MySQL","author":"Olivier DASINI","date":"16 janvier 2009","format":false,"excerpt":"En cas de perte du mot de passe root surtout si c'est votre seul compte (super) administrateur, vous vous trouvez dans une situation pour le moins embarrassante. MySQL propose un moyen de s'en sortir.","rel":"","context":"Dans &quot;Astuce&quot;","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1678,"url":"https:\/\/dasini.net\/blog\/2016\/11\/08\/deployer-un-cluster-mysql-group-replication\/","url_meta":{"origin":448,"position":2},"title":"D\u00e9ployer un cluster MySQL Group Replication","author":"Olivier DASINI","date":"8 novembre 2016","format":false,"excerpt":"Historiquement, les solutions de haute disponibilit\u00e9 (HA) avec MySQL tournent autour de la fonctionnalit\u00e9 native\u00a0MySQL Replication: replication asynchrone ou semi-synchrone. Ces modes de \u00a0replication sont tr\u00e8s largement utilis\u00e9s pour le besoins critiques d'enterprises \"at scale\" comme Facebook, Twitter, Booking.com, Uber... Aujourd'hui MySQL propose une nouvelle fonctionnalit\u00e9 native de haute disponibilit\u00e9\u2026","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Group_Replication_3_nodes.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3751,"url":"https:\/\/dasini.net\/blog\/2020\/08\/27\/resume-des-nouveautes-de-mysql-8-0-21\/","url_meta":{"origin":448,"position":3},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21","author":"Olivier DASINI","date":"27 ao\u00fbt 2020","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 13 juillet 2020, la 8.0.21.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1082,"url":"https:\/\/dasini.net\/blog\/2011\/07\/19\/suffix-log-dans-la-version-du-serveur\/","url_meta":{"origin":448,"position":4},"title":"Suffix -log dans la version du serveur","author":"Olivier DASINI","date":"19 juillet 2011","format":false,"excerpt":"La r\u00e9ponse \u00e0 une question existentielle qui m'a occup\u00e9e une petite heure... Que repr\u00e9sente la suffix de certaines versions du MySQL ? Un exemple pour \u00eatre plus clair:","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":614,"url":"https:\/\/dasini.net\/blog\/2009\/05\/06\/le-programmateur-devenements-event-scheduler-part-36\/","url_meta":{"origin":448,"position":5},"title":"Le programmateur d&rsquo;\u00e9v\u00e9nements ( Event Scheduler ) (part 3\/6)","author":"Olivier DASINI","date":"6 mai 2009","format":false,"excerpt":"G\u00e9rer les \u00e9v\u00e8nements MySQL propose plusieurs m\u00e9thodes pour visualiser les \u00e9v\u00e8nements. La m\u00e9thode la plus pratique consiste \u00e0 aller chercher l'information dans la table event de la base de donn\u00e9es des m\u00e9ta-donn\u00e9es information_schema: mysql> SELECT * FROM information_schema.EVENTS;","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=448"}],"version-history":[{"count":4,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions"}],"predecessor-version":[{"id":452,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions\/452"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}