{"action":"closed","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12104","repository_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12104/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12104/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12104/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12104","id":141680687,"number":12104,"title":"Copy Database no longer working. Please help.","user":{"login":"mrlerch","id":12500249,"avatar_url":"https://avatars.githubusercontent.com/u/12500249?v=3","gravatar_id":"","url":"https://api.github.com/users/mrlerch","html_url":"https://github.com/mrlerch","followers_url":"https://api.github.com/users/mrlerch/followers","following_url":"https://api.github.com/users/mrlerch/following{/other_user}","gists_url":"https://api.github.com/users/mrlerch/gists{/gist_id}","starred_url":"https://api.github.com/users/mrlerch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrlerch/subscriptions","organizations_url":"https://api.github.com/users/mrlerch/orgs","repos_url":"https://api.github.com/users/mrlerch/repos","events_url":"https://api.github.com/users/mrlerch/events{/privacy}","received_events_url":"https://api.github.com/users/mrlerch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"madhuracj","id":1410004,"avatar_url":"https://avatars.githubusercontent.com/u/1410004?v=3","gravatar_id":"","url":"https://api.github.com/users/madhuracj","html_url":"https://github.com/madhuracj","followers_url":"https://api.github.com/users/madhuracj/followers","following_url":"https://api.github.com/users/madhuracj/following{/other_user}","gists_url":"https://api.github.com/users/madhuracj/gists{/gist_id}","starred_url":"https://api.github.com/users/madhuracj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/madhuracj/subscriptions","organizations_url":"https://api.github.com/users/madhuracj/orgs","repos_url":"https://api.github.com/users/madhuracj/repos","events_url":"https://api.github.com/users/madhuracj/events{/privacy}","received_events_url":"https://api.github.com/users/madhuracj/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-03-17T19:13:43Z","updated_at":"2016-03-17T21:59:46Z","closed_at":"2016-03-17T21:59:46Z","body":"### Steps to reproduce\r\n1. Log in and select a database\r\n2. Click on \"Operations\" and select \"Copy database to\"\r\n3. Enter a new name for your copy and select: Structure and Data, Create Database before copying, Add auto-increment value, Add constraints, Adjust privileges, Switch to copied Database.\r\n\r\n### Expected behaviour\r\nIt should create the new database, and duplicate/create a copy of the selected database structure and data and switch to the new database.\r\n\r\n### Actual behaviour\r\nIt creates the new database, and then it throws an error: \r\nSQL query: Edit\r\n\r\nCREATE TABLE `pps_magento_03172016`.`adminnotification_inbox` (\r\n  `notification_id` int(10) UNSIGNED NOT NULL COMMENT 'Notification id',\r\n  `severity` smallint(5) UNSIGNED NOT NULL DEFAULT '0'COMMENT\r\n) ;\r\n\r\n MySQL said: Documentation\r\n#1064 - 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 ')' at line 4\r\n\r\n\r\n### Server configuration\r\n**Operating system**\r\ncentOS 6.7 (full patched)\r\n**Web server:** \r\nNginX 1.9.12\r\n**Database:**\r\nServer type: Percona Server\r\nServer version: 5.6.29-76.2 - Percona Server (GPL), Release 76.2, Revision ddf26fe\r\n**PHP version:**\r\nPHP version: 5.5.33\r\n**phpMyAdmin version:**\r\n4.5.5.1 (up to date)\r\n\r\n### Client configuration\r\n**Browser:**\r\nFirefox v38.7.0\r\n**Operating system:**\r\ncentOS 6.7 (full patched - same as server)\r\n\r\n\r\n\r\nNow usually it would just create that new database and duplicate structure and content into that new database, but not with this version phpMyAdmin. Please advise if there is anything else I can do to help identify the issue. Thanks."}}