{"action":"opened","issue":{"url":"https://api.github.com/repos/ShahriyarR/MySQL-AutoXtraBackup/issues/187","repository_url":"https://api.github.com/repos/ShahriyarR/MySQL-AutoXtraBackup","labels_url":"https://api.github.com/repos/ShahriyarR/MySQL-AutoXtraBackup/issues/187/labels{/name}","comments_url":"https://api.github.com/repos/ShahriyarR/MySQL-AutoXtraBackup/issues/187/comments","events_url":"https://api.github.com/repos/ShahriyarR/MySQL-AutoXtraBackup/issues/187/events","html_url":"https://github.com/ShahriyarR/MySQL-AutoXtraBackup/issues/187","id":273073210,"number":187,"title":"Strange behavior with database restore.","user":{"login":"Komport","id":3851382,"avatar_url":"https://avatars3.githubusercontent.com/u/3851382?v=4","gravatar_id":"","url":"https://api.github.com/users/Komport","html_url":"https://github.com/Komport","followers_url":"https://api.github.com/users/Komport/followers","following_url":"https://api.github.com/users/Komport/following{/other_user}","gists_url":"https://api.github.com/users/Komport/gists{/gist_id}","starred_url":"https://api.github.com/users/Komport/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Komport/subscriptions","organizations_url":"https://api.github.com/users/Komport/orgs","repos_url":"https://api.github.com/users/Komport/repos","events_url":"https://api.github.com/users/Komport/events{/privacy}","received_events_url":"https://api.github.com/users/Komport/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-11-10T22:01:25Z","updated_at":"2017-11-10T22:01:25Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"I am attaching steps to reproduce to explain myself clearly. \r\n1. Existing databases. I have no backup at all.\r\n```\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n| test2              |\r\n| test3              |\r\n+--------------------+\r\n6 rows in set (0.01 sec)\r\n\r\nmysql> show tables;\r\n+-----------------+\r\n| Tables_in_test2 |\r\n+-----------------+\r\n| test            |\r\n+-----------------+\r\n1 row in set (0.00 sec)\r\n\r\n```\r\n2. Take Full backup\r\n```\r\n[root@server1 inc]# autoxtrabackup --backup\r\nmysqladmin: [Warning] Using a password on the command line interface can be insecure.\r\n```\r\n3. Drop one Database\r\n```\r\nmysql> drop database test2;\r\nQuery OK, 1 row affected (0.66 sec)\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n| test3              |\r\n+--------------------+\r\n5 rows in set (0.09 sec)\r\n```\r\n4. Take Inc backup\r\n```\r\n[root@server1 inc]# autoxtrabackup --backup\r\nmysqladmin: [Warning] Using a password on the command line interface can be insecure.\r\n```\r\n5.Prepare and restore backup\r\n```\r\n[root@server1 inc]# autoxtrabackup --prepare\r\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\r\nPreparing full/inc backups!\r\nWhat do you want to do?\r\n1. Prepare Backups and keep for future usage. NOTE('Once Prepared Backups Can not be prepared Again')\r\n2. Prepare Backups and restore/recover/copy-back immediately\r\n3. Just copy-back previously prepared backups\r\nPlease Choose one of options and type 1 or 2 or 3: 1\r\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\r\n[root@server1 inc]# autoxtrabackup --prepare\r\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\r\nPreparing full/inc backups!\r\nWhat do you want to do?\r\n1. Prepare Backups and keep for future usage. NOTE('Once Prepared Backups Can not be prepared Again')\r\n2. Prepare Backups and restore/recover/copy-back immediately\r\n3. Just copy-back previously prepared backups\r\nPlease Choose one of options and type 1 or 2 or 3: 3\r\n\r\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\r\n```\r\n6. Check Databases  - Here I am expecting not to see test2 database. Because I have dropped it before I took backup. But it is there and empty. \r\n```\r\nmysql> show databases;\r\nERROR 2006 (HY000): MySQL server has gone away\r\nNo connection. Trying to reconnect...\r\nConnection id:    3\r\nCurrent database: *** NONE ***\r\n\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n| test2              |\r\n| test3              |\r\n+--------------------+\r\n6 rows in set (0.09 sec)\r\nmysql> use test2;\r\nDatabase changed\r\nmysql> show tables;\r\nEmpty set (0.00 sec)\r\n```"}}
{"actor":{"display_login":"Komport"}}