{"id":75,"date":"2012-10-01T13:48:26","date_gmt":"2012-10-01T12:48:26","guid":{"rendered":"http:\/\/www.bocciolesi.fr\/tutoriels-et-cours\/?p=75"},"modified":"2017-02-24T14:18:44","modified_gmt":"2017-02-24T13:18:44","slug":"replication-mysql-avec-phpmyadmin","status":"publish","type":"post","link":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/","title":{"rendered":"R\u00e9plication MySql avec PhpMyAdmin  sur 2 serveurs distincts"},"content":{"rendered":"<div class=\"pdfprnt-buttons pdfprnt-buttons-post pdfprnt-top-right\"><a href=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/75?print=pdf\" class=\"pdfprnt-button pdfprnt-button-pdf\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/plugins\/pdf-print\/images\/pdf.png\" alt=\"image_pdf\" title=\"Afficher le PDF\" \/><span class=\"pdfprnt-button-title pdfprnt-button-pdf-title\">Enregistrer en PDF<\/span><\/a><a href=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/75?print=print\" class=\"pdfprnt-button pdfprnt-button-print\" target=\"_blank\"><\/a><\/div><p><span style=\"color: #3366ff;\"><strong>I\u25ba : sur le serveur Ma\u00eetre, configurez la r\u00e9plication comme suit :<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"font-size: 1rem; line-height: 1.714285714;\">Dans l&#8217;onglet r\u00e9plication, choisissez l&#8217;option <em>configurer le serveur ma\u00eetre<\/em>.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-77 alignnone\" src=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture1.png\" alt=\"Capture\" width=\"656\" height=\"468\" srcset=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture1.png 656w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture1-300x214.png 300w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture1-624x445.png 624w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 1rem; line-height: 1.714285714;\">Editer le fichier <\/span><strong style=\"font-size: 1rem; line-height: 1.714285714;\">\/etc\/mysql\/my.cnf<\/strong><\/p>\n<ul>\n<li><span style=\"line-height: 1.714285714; font-size: 1rem;\">Red\u00e9marrez mysql : <\/span><strong style=\"line-height: 1.714285714; font-size: 1rem;\">\/etc\/init.d\/mysql restart<\/strong><\/li>\n<li><span style=\"line-height: 1.714285714; font-size: 1rem;\">Puis faites\u00a0ex\u00e9cuter<\/span><span style=\"line-height: 1.714285714; font-size: 1rem;\">\u00a0dans phpMyAdmin<\/span><\/li>\n<li>Ajouter un nouvel utilisateur pour la r\u00e9plication et donner lui tous les privil\u00e8ges n\u00e9cessaires<br \/>\n<a href=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-80 alignnone\" src=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture2.png\" alt=\"Capture\" width=\"577\" height=\"372\" srcset=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture2.png 577w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture2-300x193.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>CREATE USER &#8216;replicant&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;***&#8217;;<br \/>\n<span style=\"line-height: 1.714285714; font-size: 1rem;\">GRANT REPLICATION SLAVE , REPLICATION CLIENT ON * . * TO &#8216;replicant&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;***&#8217;;<\/span><\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"font-size: 1.285714286rem; line-height: 1.6;\">II : sur le serveur esclave, configurez la r\u00e9plication comme suit :<\/span><\/span><\/p>\n<ul>\n<li><span style=\"line-height: 14px;\">Dans l&#8217;onglet r\u00e9plication, configurez :<\/span><\/li>\n<li>Vous devrez ajouter le <strong>server-id<\/strong> propos\u00e9 par phpMyAdmin dans <strong>\/etc\/mysql\/my.cnf<\/strong> et red\u00e9marrez mysql (pensez \u00e0 ajouter <strong>slave-skip-errors=1062,1053 !<\/strong>)<\/li>\n<li>puis faire \u00e9x\u00e9cuter dans phpMyAdmin<\/li>\n<li>Faites reconfigurer le serveur ma\u00eetre en saisissant les informations du serveur\u00a0ma\u00eetre\u00a0 <a href=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture0.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-84 alignnone\" src=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture0.png\" alt=\"Capture0\" width=\"557\" height=\"230\" srcset=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture0.png 557w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture0-300x123.png 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/a><\/li>\n<\/ul>\n<p>Ceci revient \u00e0 faire en ligne de commande : et qui \u00e9ditera au final le fichier <strong><span style=\"color: #3366ff;\">master.info<\/span><\/strong> qui se trouve sur le serveur esclave :<\/p>\n<p><a href=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2012\/10\/Capture17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1128\" src=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2012\/10\/Capture17.png\" alt=\"Capture\" width=\"620\" height=\"204\" srcset=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2012\/10\/Capture17.png 620w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2012\/10\/Capture17-300x98.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p><span style=\"line-height: 1.714285714; font-size: 1rem;\">\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"line-height: 14px;\">On obtient alors cet \u00e9cran :<\/span><\/li>\n<li><a href=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-83 alignnone\" src=\"https:\/\/www.mb-creation-web.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture3.png\" alt=\"Capture\" width=\"486\" height=\"277\" srcset=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture3.png 486w, https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/02\/Capture3-300x170.png 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>On pourra synchroniser les donn\u00e9es afin de copier toute la base de donn\u00e9es vers le serveur esclave et ensuite d\u00e9marrer compl\u00e8tement le serveur esclave (ce qui correspond \u00e0 d\u00e9marrer d&#8217;abord le fil I\/O qui lit les requ\u00eates du ma\u00eetre et le splace dans le relay-lo et ensuite le fil mysql qui lit le relay-log et \u00e9x\u00e9cute le sql)<\/p>\n<p><strong><code>START SLAVE<\/code><\/strong>, appel\u00e9 sans option, d\u00e9marre les deux threads esclaves.(processus l\u00e9ger au sein d&#8217;un m\u00eame processus)<br \/>\nLe thread<strong>\u00a0I\/O<\/strong>\u00a0lire les requ\u00eates du ma\u00eetre et les stocke dans le log de relais.<br \/>\nLe thread\u00a0<strong>SQL<\/strong>\u00a0lire le log de relais, et ex\u00e9cute les requ\u00eates.<br \/>\n<strong>START SLAVE SQL_THREAD;<\/strong><br \/>\n<strong>START SLAVE IO_THREAD;<\/strong><\/p>\n<ul>\n<li>\n<h2><span style=\"font-size: 1rem; line-height: 1.714285714; text-decoration: underline; color: #000080;\">Conf. de my.cnf sur le slave :<\/span><\/h2>\n<\/li>\n<\/ul>\n<p><span style=\"line-height: 1.714285714; font-size: 1rem;\">[client]<\/span><br \/>\nport = 3306<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\n[mysqld_safe]<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\nnice = 0<\/p>\n<p>[mysqld]<br \/>\nuser = mysql<br \/>\npid-file = \/var\/run\/mysqld\/mysqld.pid<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\nport = 3306<br \/>\nbasedir = \/usr<br \/>\ndatadir = \/var\/lib\/mysql<br \/>\ntmpdir = \/tmp<br \/>\nlanguage = \/usr\/share\/mysql\/english<br \/>\nskip-external-locking<br \/>\nlanguage = \/usr\/share\/mysql\/french<br \/>\nkey_buffer = 32M<br \/>\nquery_cache_size = 32M<br \/>\nmax_allowed_packet = 16M<br \/>\nthread_stack = 192K<br \/>\nthread_cache_size = 8<br \/>\nmyisam-recover = BACKUP<br \/>\nquery_cache_limit = 2M<br \/>\nquery_cache_size = 32M<br \/>\nlog_slow_queries = \/var\/log\/mysql\/mysql-slow.log<br \/>\nmax_binlog_size = 100M<\/p>\n<p>#r\u00e9plication<br \/>\n<strong>server-id=1360067571<\/strong><br \/>\n<strong>slave-skip-errors=1062,1053<\/strong><br \/>\n[mysqldump]<br \/>\nquick<br \/>\nquote-names<br \/>\nmax_allowed_packet = 16M<\/p>\n<p>[mysql]<\/p>\n<p>[isamchk]<br \/>\nkey_buffer = 16M<br \/>\n!includedir \/etc\/mysql\/conf.d\/<\/p>\n<ul>\n<li>\n<h2><span style=\"text-decoration: underline; font-size: 1.285714286rem; line-height: 1.6; color: #000080;\">conf. de my.cnf sur le ma\u00eetre :<\/span><\/h2>\n<\/li>\n<\/ul>\n<p>[client]<br \/>\nport = 3306<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\n[mysqld_safe]<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\nnice = 0<br \/>\n[mysqld]<br \/>\nuser = mysql<br \/>\npid-file = \/var\/run\/mysqld\/mysqld.pid<br \/>\nsocket = \/var\/run\/mysqld\/mysqld.sock<br \/>\nport = 3306<br \/>\nbasedir = \/usr<br \/>\ndatadir = \/var\/lib\/mysql<br \/>\ntmpdir = \/tmp<br \/>\nlanguage = \/usr\/share\/mysql\/english<br \/>\nskip-external-locking<br \/>\nlanguage = \/usr\/share\/mysql\/french<br \/>\nkey_buffer = 32M<br \/>\nquery_cache_size = 32M<br \/>\nmax_allowed_packet = 16M<br \/>\nthread_stack = 192K<br \/>\nmyisam-recover = BACKUP<br \/>\nquery_cache_limit = 2M<br \/>\nquery_cache_size = 32M<br \/>\nlog_slow_queries = \/var\/log\/mysql\/mysql-slow.log<br \/>\nmax_binlog_size = 100M<\/p>\n<p>#replication<br \/>\n<strong>server-id=8345038<\/strong><br \/>\n<strong>log-bin=mysql-bin<\/strong><br \/>\n<strong>log-error=mysql-bin.err<\/strong><br \/>\n<strong>binlog_do_db=centrale<\/strong><\/p>\n<p>[mysqldump]<br \/>\nquick<br \/>\nquote-names<br \/>\nmax_allowed_packet = 16M<\/p>\n<p>[mysql]<\/p>\n<p>[isamchk]<br \/>\nkey_buffer = 16M<\/p>\n<p>!includedir \/etc\/mysql\/conf.d\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u25ba : sur le serveur Ma\u00eetre, configurez la r\u00e9plication comme suit : Dans l&#8217;onglet r\u00e9plication, choisissez l&#8217;option configurer le serveur ma\u00eetre. &nbsp; Editer le fichier \/etc\/mysql\/my.cnf Red\u00e9marrez mysql &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,5,39],"tags":[19],"class_list":["post-75","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb","category-mysql","category-tutoriels","tag-phpmyadmin-mysql-replication"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours\" \/>\n<meta property=\"og:description\" content=\"I\u25ba : sur le serveur Ma\u00eetre, configurez la r\u00e9plication comme suit : Dans l&#8217;onglet r\u00e9plication, choisissez l&#8217;option configurer le serveur ma\u00eetre. &nbsp; Editer le fichier \/etc\/mysql\/my.cnf Red\u00e9marrez mysql ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels et Cours\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-01T12:48:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-24T13:18:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"424\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michel BOCCIOLESI\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michel BOCCIOLESI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/\",\"name\":\"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours\",\"isPartOf\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"datePublished\":\"2012-10-01T12:48:26+00:00\",\"dateModified\":\"2017-02-24T13:18:44+00:00\",\"author\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\"},\"breadcrumb\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"contentUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"width\":424,\"height\":283,\"caption\":\"Cours et tutoriels MySQL et Maria DB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\",\"name\":\"Tutoriels et Cours\",\"description\":\"Michel Bocciolesi | Formateur Consultant en Informatique\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\",\"name\":\"Michel BOCCIOLESI\",\"description\":\"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.\",\"sameAs\":[\"https:\/\/www.mb-creation-web.fr\"],\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours","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":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/","og_locale":"fr_FR","og_type":"article","og_title":"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours","og_description":"I\u25ba : sur le serveur Ma\u00eetre, configurez la r\u00e9plication comme suit : Dans l&#8217;onglet r\u00e9plication, choisissez l&#8217;option configurer le serveur ma\u00eetre. &nbsp; Editer le fichier \/etc\/mysql\/my.cnf Red\u00e9marrez mysql ...","og_url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/","og_site_name":"Tutoriels et Cours","article_published_time":"2012-10-01T12:48:26+00:00","article_modified_time":"2017-02-24T13:18:44+00:00","og_image":[{"width":424,"height":283,"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","type":"image\/jpeg"}],"author":"Michel BOCCIOLESI","twitter_misc":{"\u00c9crit par":"Michel BOCCIOLESI","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/","name":"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts - Tutoriels et Cours","isPartOf":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","datePublished":"2012-10-01T12:48:26+00:00","dateModified":"2017-02-24T13:18:44+00:00","author":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe"},"breadcrumb":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#primaryimage","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","contentUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","width":424,"height":283,"caption":"Cours et tutoriels MySQL et Maria DB"},{"@type":"BreadcrumbList","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-avec-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/"},{"@type":"ListItem","position":2,"name":"R\u00e9plication MySql avec PhpMyAdmin sur 2 serveurs distincts"}]},{"@type":"WebSite","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/","name":"Tutoriels et Cours","description":"Michel Bocciolesi | Formateur Consultant en Informatique","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe","name":"Michel BOCCIOLESI","description":"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.","sameAs":["https:\/\/www.mb-creation-web.fr"],"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/"}]}},"_links":{"self":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":35,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":1631,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/75\/revisions\/1631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media\/1547"}],"wp:attachment":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}