{"id":23153,"date":"2019-01-25T06:21:03","date_gmt":"2019-01-25T14:21:03","guid":{"rendered":"https:\/\/kinsta.com\/?post_type=knowledgebase&#038;p=8988"},"modified":"2025-10-01T20:53:50","modified_gmt":"2025-10-01T19:53:50","slug":"comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin","status":"publish","type":"post","link":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/","title":{"rendered":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin"},"content":{"rendered":"<p>La plupart des h\u00e9bergeurs WordPress, y compris Kinsta, ont des <a href=\"https:\/\/kinsta.com\/fr\/blog\/sauvegardes-wordpress\/\" target=\"_blank\" rel=\"noopener noreferrer\">sauvegardes automatiques<\/a> qui vous permettent de restaurer en cas d&rsquo;urgence. Cependant, il peut arriver que vous ayez besoin de restaurer et\/ou de t\u00e9l\u00e9charger manuellement <a href=\"https:\/\/kinsta.com\/fr\/blog\/bases-de-donnees-wordpress\/\">votre propre base de donn\u00e9es MySQL<\/a>.<\/p>\n<p>Cela peut \u00eatre d\u00fb au fait que vous changez d\u2019h\u00e9bergeur et migrez votre site ou que vous souhaitez faire du <a href=\"https:\/\/kinsta.com\/fr\/blog\/installer-wordpress-localement\/\" target=\"_blank\" rel=\"noopener noreferrer\">d\u00e9veloppement local<\/a>. Dans tous les cas, vous pouvez suivre ce tutoriel simple et rapide ci-dessous sur comment restaurer la base de donn\u00e9es MySQL en utilisant phpMyAdmin.<\/p>\n<p>Lectures sugg\u00e9r\u00e9es : <a href=\"https:\/\/kinsta.com\/fr\/blog\/exporter-site-wordpress\/\">Comment exporter un site WordPress<\/a><\/p>\n<h3>Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin<\/h3>\n<p>PhpMyAdmin est un outil open source gratuit disponible via votre navigateur qui est utilis\u00e9 pour g\u00e9rer l&rsquo;administration de <a href=\"https:\/\/kinsta.com\/fr\/blog\/qu-est-ce-que-mysql\/\">MySQL<\/a> ou MariaDB. Il peut \u00eatre utilis\u00e9 pour toutes sortes d&rsquo;op\u00e9rations diff\u00e9rentes, telles que la migration des bases de donn\u00e9es, la gestion des tables, des index et l&rsquo;ex\u00e9cution des instructions SQL. Aujourd&rsquo;hui nous allons simplement restaurer une base de donn\u00e9es WordPress MySQL avec phpMyAdmin.<\/p>\n<p>Remarque : Ce tutoriel suppose que vous avez d\u00e9j\u00e0 un fichier *.sql de sauvegarde ou export\u00e9 que vous allez importer. Sinon, consultez notre tutoriel sur la <a href=\"https:\/\/kinsta.com\/fr\/blog\/comment-sauvegarder-base-de-donnees-mysql-avec-phpmyadmin\/\" target=\"_blank\" rel=\"noopener noreferrer\">sauvegarde de votre base de donn\u00e9es MySQL avec phpMyAdmin<\/a>.<\/p>\n<h3>\u00c9tape 1<\/h3>\n<p>Connectez-vous \u00e0 phpMyAdmin. Avec Kinsta, nous avons un lien facile d&rsquo;acc\u00e8s pour se <a href=\"https:\/\/kinsta.com\/fr\/docs\/hebergement-wordpress\/gestion-base-de-donnees\/acces-base-donnees-wordpress\/\" target=\"_blank\" rel=\"noopener noreferrer\">connecter \u00e0 phpMyAdmin<\/a> depuis le tableau de bord MyKinsta. En fonction de votre h\u00e9bergeur WordPress, celui-ci peut \u00e9galement se trouver dans votre compte cPanel.<\/p>\n<figure id=\"attachment_50463\" aria-describedby=\"caption-attachment-50463\" style=\"width: 2880px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50463\" src=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1.png\" alt=\"Connectez-vous \u00e0 PHPMyAdmin.\" width=\"2880\" height=\"1520\" srcset=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1.png 2880w, https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1-300x158.png 300w, https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1-1024x540.png 1024w, https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1-768x405.png 768w, https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1-1536x811.png 1536w, https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/mykinsta-log-into-phpmyadmin-1-2048x1081.png 2048w\" sizes=\"auto, (max-width: 2880px) 100vw, 2880px\" \/><figcaption id=\"caption-attachment-50463\" class=\"wp-caption-text\">Connectez-vous \u00e0 PHPMyAdmin.<\/figcaption><\/figure>\n<h3>\u00c9tape 2<\/h3>\n<p>Cliquez dans votre base de donn\u00e9es WordPress. Le nom correspondra tr\u00e8s probablement au nom de votre site.<\/p>\n<figure id=\"attachment_82177\" aria-describedby=\"caption-attachment-82177\" style=\"width: 1500px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82177 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2017\/01\/kinsta-site-database.jpg\" alt=\"Clique sur la base de donn\u00e9es MySQL de ton site Kinsta dans phpMyAdmin.\" width=\"1500\" height=\"798\"><figcaption id=\"caption-attachment-82177\" class=\"wp-caption-text\">Clique sur la base de donn\u00e9es MySQL de ton site Kinsta dans phpMyAdmin.<\/figcaption><\/figure>\n<h3>\u00c9tape 3<\/h3>\n<p>Cliquez sur l&rsquo;onglet \u00ab\u00a0Importer\u00a0\u00bb puis sur \u00ab\u00a0Choisir le fichier\u00a0\u00bb. S\u00e9lectionnez votre sauvegarde\/exportation de fichier *.sql. Et puis cliquez sur \u00ab\u00a0Go\u00a0\u00bb.<\/p>\n<aside role=\"note\" class=\"wp-block-kinsta-notice is-style-important\">\n            <h3>Important<\/h3>\n        <p>L&rsquo;importation de votre fichier *.sql \u00e9crasera le contenu actuel de votre base de donn\u00e9es. Si vous n&rsquo;\u00eates pas \u00e0 l&rsquo;aise de le faire, veuillez d&rsquo;abord v\u00e9rifier aupr\u00e8s d&rsquo;un d\u00e9veloppeur.<\/p>\n<\/aside>\n\n<figure id=\"attachment_82178\" aria-describedby=\"caption-attachment-82178\" style=\"width: 1500px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82178 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2017\/01\/phpmyadmin-choose-import-file.jpg\" alt=\"Importer la base de donn\u00e9es dans phpMyAdmin.\" width=\"1500\" height=\"798\"><figcaption id=\"caption-attachment-82178\" class=\"wp-caption-text\">Importer la base de donn\u00e9es dans phpMyAdmin.<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La plupart des h\u00e9bergeurs WordPress, y compris Kinsta, ont des sauvegardes automatiques qui vous permettent de restaurer en cas d&rsquo;urgence. Cependant, il peut arriver que vous &#8230;<\/p>\n","protected":false},"author":38,"featured_media":23160,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[109,47],"topic":[987,992],"class_list":["post-23153","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-mysql","tag-webdev","topic-apprendre-php","topic-base-de-donnees-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.6 (Yoast SEO v24.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Vous changez peut-\u00eatre d&#039;h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d&#039;oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"Vous changez peut-\u00eatre d&#039;h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d&#039;oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstafrance\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/fm.brianleejackson\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-25T14:21:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T19:53:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1460\" \/>\n\t<meta property=\"og:image:height\" content=\"730\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brian Jackson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"Vous changez peut-\u00eatre d&#039;h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d&#039;oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\" \/>\n<meta name=\"twitter:creator\" content=\"@brianleejackson\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_fr\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jackson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\"},\"author\":{\"name\":\"Brian Jackson\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\"},\"headline\":\"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin\",\"datePublished\":\"2019-01-25T14:21:03+00:00\",\"dateModified\":\"2025-10-01T19:53:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\"},\"wordCount\":403,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\",\"keywords\":[\"mySQL\",\"webdev\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\",\"url\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\",\"name\":\"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\",\"datePublished\":\"2019-01-25T14:21:03+00:00\",\"dateModified\":\"2025-10-01T19:53:50+00:00\",\"description\":\"Vous changez peut-\u00eatre d'h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d'oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\",\"contentUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png\",\"width\":1460,\"height\":730,\"caption\":\"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es MySQL\",\"item\":\"https:\/\/kinsta.com\/fr\/sujets\/base-de-donnees-mysql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/fr\/#website\",\"url\":\"https:\/\/kinsta.com\/fr\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Solutions d&#039;h\u00e9bergement premium, rapides et s\u00e9curis\u00e9es\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/kinstafrance\/\",\"https:\/\/x.com\/kinsta_fr\",\"https:\/\/www.instagram.com\/kinstahosting\/\",\"https:\/\/www.linkedin.com\/company\/kinsta\/\",\"https:\/\/www.pinterest.com\/kinstahosting\/\",\"https:\/\/www.youtube.com\/c\/Kinsta\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\",\"name\":\"Brian Jackson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"caption\":\"Brian Jackson\"},\"description\":\"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.\",\"sameAs\":[\"https:\/\/www.facebook.com\/fm.brianleejackson\",\"https:\/\/www.linkedin.com\/in\/brianleejackson\",\"https:\/\/x.com\/brianleejackson\"],\"url\":\"https:\/\/kinsta.com\/fr\/blog\/author\/brianjackson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin","description":"Vous changez peut-\u00eatre d'h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d'oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.","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:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin","og_description":"Vous changez peut-\u00eatre d'h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d'oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.","og_url":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstafrance\/","article_author":"https:\/\/www.facebook.com\/fm.brianleejackson","article_published_time":"2019-01-25T14:21:03+00:00","article_modified_time":"2025-10-01T19:53:50+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","type":"image\/png"}],"author":"Brian Jackson","twitter_card":"summary_large_image","twitter_description":"Vous changez peut-\u00eatre d'h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d'oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.","twitter_image":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","twitter_creator":"@brianleejackson","twitter_site":"@kinsta_fr","twitter_misc":{"\u00c9crit par":"Brian Jackson","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/"},"author":{"name":"Brian Jackson","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7"},"headline":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin","datePublished":"2019-01-25T14:21:03+00:00","dateModified":"2025-10-01T19:53:50+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/"},"wordCount":403,"publisher":{"@id":"https:\/\/kinsta.com\/fr\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","keywords":["mySQL","webdev"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/","url":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/","name":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin","isPartOf":{"@id":"https:\/\/kinsta.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","datePublished":"2019-01-25T14:21:03+00:00","dateModified":"2025-10-01T19:53:50+00:00","description":"Vous changez peut-\u00eatre d'h\u00e9bergeur WordPress ou faites du d\u00e9veloppement local. Jetez un coup d'oeil \u00e0 ce tutoriel rapide sur la fa\u00e7on de restaurer une base de donn\u00e9es MySQL en utilisant phpMyAdmin.","breadcrumb":{"@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#primaryimage","url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","contentUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/01\/comment-restaurer-une-base-de-donnees-mysql-avec-phpmyadmin-.png","width":1460,"height":730,"caption":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin"},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/fr\/blog\/comment-restaurer-base-de-donnees-mysql-avec-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es MySQL","item":"https:\/\/kinsta.com\/fr\/sujets\/base-de-donnees-mysql\/"},{"@type":"ListItem","position":3,"name":"Comment restaurer une base de donn\u00e9es MySQL avec phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/fr\/#website","url":"https:\/\/kinsta.com\/fr\/","name":"Kinsta\u00ae","description":"Solutions d&#039;h\u00e9bergement premium, rapides et s\u00e9curis\u00e9es","publisher":{"@id":"https:\/\/kinsta.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/fr\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kinstafrance\/","https:\/\/x.com\/kinsta_fr","https:\/\/www.instagram.com\/kinstahosting\/","https:\/\/www.linkedin.com\/company\/kinsta\/","https:\/\/www.pinterest.com\/kinstahosting\/","https:\/\/www.youtube.com\/c\/Kinsta"]},{"@type":"Person","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7","name":"Brian Jackson","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","caption":"Brian Jackson"},"description":"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.","sameAs":["https:\/\/www.facebook.com\/fm.brianleejackson","https:\/\/www.linkedin.com\/in\/brianleejackson","https:\/\/x.com\/brianleejackson"],"url":"https:\/\/kinsta.com\/fr\/blog\/author\/brianjackson\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/23153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/comments?post=23153"}],"version-history":[{"count":14,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/23153\/revisions"}],"predecessor-version":[{"id":50465,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/23153\/revisions\/50465"}],"alternate":[{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/es"},{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/it"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/fr"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/de"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/pt"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/translations\/nl"},{"href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/23153\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/media\/23160"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/media?parent=23153"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/tags?post=23153"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/topic?post=23153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}