{"id":158,"date":"2013-01-16T21:54:06","date_gmt":"2013-01-16T21:54:06","guid":{"rendered":"https:\/\/www.demenageur-site.com\/blog\/?p=158"},"modified":"2013-01-16T21:54:50","modified_gmt":"2013-01-16T21:54:50","slug":"mysql-erreur-de-guillemets-doubles-a-limport","status":"publish","type":"post","link":"https:\/\/www.demenageur-site.com\/blog\/2013\/01\/mysql-erreur-de-guillemets-doubles-a-limport\/","title":{"rendered":"Mysql : erreur de guillemets doubles \u00e0 l&rsquo;import"},"content":{"rendered":"<p>Dans PhpMyAdmin, si lors de l&rsquo;import d&rsquo;un fichier .sql vous avez une erreur, alors que le fichier semble parfait, m\u00e9fiez vous des guillemets doubles !<\/p>\n<p>Si votre fichier sql est de ce type :<\/p>\n<pre>CREATE TABLE \"backend_layout\" (\r\n\u00a0 \"uid\" int(11) NOT NULL,\r\n\u00a0 \"pid\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_oid\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_id\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_wsid\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_label\" varchar(255) NOT NULL DEFAULT '',\r\n\u00a0 \"t3ver_state\" tinyint(4) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_stage\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_count\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_tstamp\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3ver_move_id\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"t3_origuid\" int(11) NOT NULL DEFAULT '0',\r\n\u00a0 \"tstamp\" int(11) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 \"crdate\" int(11) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 \"cruser_id\" int(11) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 \"hidden\" tinyint(4) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 \"deleted\" tinyint(4) NOT NULL DEFAULT '0',\r\n\u00a0 \"sorting\" int(11) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 \"title\" varchar(255) NOT NULL DEFAULT '',\r\n\u00a0 \"description\" text NOT NULL,\r\n\u00a0 \"config\" text NOT NULL,\r\n\u00a0 \"icon\" text NOT NULL,\r\n\u00a0 PRIMARY KEY (\"uid\"),\r\n\u00a0 KEY \"parent\" (\"pid\"),\r\n\u00a0 KEY \"t3ver_oid\" (\"t3ver_oid\",\"t3ver_wsid\")\r\n) AUTO_INCREMENT=1 ;<\/pre>\n<p>Vous voyez qu&rsquo;on a ici des guillemets doubles\u00a0 au lieu des guillemets simples pench\u00e9s habituels &lt;`&gt; : il faut alors importer le fichier en utilisant le param\u00e8tre de compatibilit\u00e9 \u00ab\u00a0MSSQL\u00a0\u00bb<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans PhpMyAdmin, si lors de l&rsquo;import d&rsquo;un fichier .sql vous avez une erreur, alors que le fichier semble parfait, m\u00e9fiez vous des guillemets doubles ! Si votre fichier sql est de ce type : CREATE TABLE \u00ab\u00a0backend_layout\u00a0\u00bb ( \u00a0 \u00ab\u00a0uid\u00a0\u00bb<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/www.demenageur-site.com\/blog\/2013\/01\/mysql-erreur-de-guillemets-doubles-a-limport\/\">Lire la suite &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":2,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"predecessor-version":[{"id":160,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions\/160"}],"wp:attachment":[{"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.demenageur-site.com\/blog\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}