{"action":"opened","issue":{"url":"https://api.github.com/repos/ifsnop/mysqldump-php/issues/105","repository_url":"https://api.github.com/repos/ifsnop/mysqldump-php","labels_url":"https://api.github.com/repos/ifsnop/mysqldump-php/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/ifsnop/mysqldump-php/issues/105/comments","events_url":"https://api.github.com/repos/ifsnop/mysqldump-php/issues/105/events","html_url":"https://github.com/ifsnop/mysqldump-php/issues/105","id":171876214,"number":105,"title":"SQL syntax for keys","user":{"login":"wrongware","id":172640,"avatar_url":"https://avatars.githubusercontent.com/u/172640?v=3","gravatar_id":"","url":"https://api.github.com/users/wrongware","html_url":"https://github.com/wrongware","followers_url":"https://api.github.com/users/wrongware/followers","following_url":"https://api.github.com/users/wrongware/following{/other_user}","gists_url":"https://api.github.com/users/wrongware/gists{/gist_id}","starred_url":"https://api.github.com/users/wrongware/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wrongware/subscriptions","organizations_url":"https://api.github.com/users/wrongware/orgs","repos_url":"https://api.github.com/users/wrongware/repos","events_url":"https://api.github.com/users/wrongware/events{/privacy}","received_events_url":"https://api.github.com/users/wrongware/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-18T11:09:40Z","updated_at":"2016-08-18T11:09:40Z","closed_at":null,"body":"Hello,\r\n\r\nI am not sure whether is bug or not but i have tried export wordpress database and import again and i got error\r\n\r\n> ERROR 1064 (42000) at line 25: 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 '(`meta_id`),\r\n>   KEY `comment_id` (`comment_id`),\r\n>   KEY `meta_key` (`meta_key`(191' at line 6\r\n\r\nIt seems like syntax error in KEY part of table creation ( _KEY `meta_key` (`meta_key`(191))_). Is this syntax support by MySQL 5.7?\r\n\r\n(Dump comes from MySQL 5.5)\r\n\r\n```\r\nCREATE TABLE `tvrv_commentmeta` (\r\n  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,\r\n  `meta_value` longtext COLLATE utf8mb4_unicode_ci,\r\n  PRIMARYKEY (`meta_id`),\r\n  KEY `comment_id` (`comment_id`),\r\n  KEY `meta_key` (`meta_key`(191))\r\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n```"}}
{"actor":{"display_login":"wrongware"}}