{"id":660,"date":"2016-06-01T01:01:49","date_gmt":"2016-06-01T01:01:49","guid":{"rendered":"http:\/\/opiniaodetudo.com\/?p=660"},"modified":"2016-06-01T01:03:06","modified_gmt":"2016-06-01T01:03:06","slug":"erro-ao-restaurar-banco-de-dados-mysql-no-phpmyadmin","status":"publish","type":"post","link":"https:\/\/opiniaodetudo.com\/index.php\/2016\/06\/01\/erro-ao-restaurar-banco-de-dados-mysql-no-phpmyadmin\/","title":{"rendered":"Erro ao Restaurar Banco de dados MYSQL no PhpMyAdmin"},"content":{"rendered":"<p>Recentemente fui realizar uma transfer\u00eancia de dados de um banco MySQL durante a restaura\u00e7\u00e3o\u00a0atrav\u00e9s do PHPMyAdmin retornava a seguinte mensagem de erro:<\/p>\n<p><strong class=\"bbc\">You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#8216;TYPE=MyISAM&#8217; at line 34<\/strong><\/p>\n<p><a href=\"https:\/\/opiniaodetudo.com\/wp-content\/uploads\/2016\/06\/Erro-Mysql.jpg\" rel=\"attachment wp-att-661\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"661\" data-permalink=\"https:\/\/opiniaodetudo.com\/index.php\/2016\/06\/01\/erro-ao-restaurar-banco-de-dados-mysql-no-phpmyadmin\/erro-mysql\/\" data-orig-file=\"https:\/\/opiniaodetudo.com\/wp-content\/uploads\/2016\/06\/Erro-Mysql.jpg\" data-orig-size=\"1118,312\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Erro Mysql\" data-image-description=\"\" data-medium-file=\"https:\/\/opiniaodetudo.com\/wp-content\/uploads\/2016\/06\/Erro-Mysql-300x84.jpg\" data-large-file=\"https:\/\/opiniaodetudo.com\/wp-content\/uploads\/2016\/06\/Erro-Mysql-1024x286.jpg\" class=\"alignnone wp-image-661\" src=\"https:\/\/opiniaodetudo.com\/wp-content\/uploads\/2016\/06\/Erro-Mysql-300x84.jpg\" alt=\"Erro Mysql\" width=\"673\" height=\"214\" \/><\/a><\/p>\n<p>Consegui resolver o problema abrindo o arquivo do Backup no bloco de notas e trocando em todo arquivo a seguinte linha:<\/p>\n<p>TYPE=MyISAM;<\/p>\n<p>por<\/p>\n<p>engine=MyISAM;<\/p>\n<p>Em vers\u00f5es mais atuais do MYSQL quando voc\u00ea cria tabelas, elas j\u00e1 s\u00e3o criadas por padr\u00e3o usando a engine\u00a0InnoDB.<\/p>\n<p>A diferen\u00e7a entre as duas\u00a0seria que InnoDB suporta TRANSA\u00c7\u00d5ES e CONSTRAINTS de chave estrangeira e MyISAM n\u00e3o.<\/p>\n<p>&nbsp;<\/p>\n<p>Espero ter ajudado!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recentemente fui realizar uma transfer\u00eancia de dados de um banco MySQL durante a restaura\u00e7\u00e3o\u00a0atrav\u00e9s do PHPMyAdmin retornava a seguinte mensagem de erro: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#8216;TYPE=MyISAM&#8217; at line 34 Consegui resolver o problema [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":""},"categories":[33],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6N3xn-aE","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/posts\/660"}],"collection":[{"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/comments?post=660"}],"version-history":[{"count":2,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/posts\/660\/revisions"}],"predecessor-version":[{"id":664,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/posts\/660\/revisions\/664"}],"wp:attachment":[{"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/media?parent=660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/categories?post=660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opiniaodetudo.com\/index.php\/wp-json\/wp\/v2\/tags?post=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}