{"action":"created","issue":{"url":"https://api.github.com/repos/humanmade/backupwordpress/issues/827","labels_url":"https://api.github.com/repos/humanmade/backupwordpress/issues/827/labels{/name}","comments_url":"https://api.github.com/repos/humanmade/backupwordpress/issues/827/comments","events_url":"https://api.github.com/repos/humanmade/backupwordpress/issues/827/events","html_url":"https://github.com/humanmade/backupwordpress/issues/827","id":92522754,"number":827,"title":"MySQL views being treated as tables","user":{"login":"samwilson","id":213655,"avatar_url":"https://avatars.githubusercontent.com/u/213655?v=3","gravatar_id":"","url":"https://api.github.com/users/samwilson","html_url":"https://github.com/samwilson","followers_url":"https://api.github.com/users/samwilson/followers","following_url":"https://api.github.com/users/samwilson/following{/other_user}","gists_url":"https://api.github.com/users/samwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/samwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samwilson/subscriptions","organizations_url":"https://api.github.com/users/samwilson/orgs","repos_url":"https://api.github.com/users/samwilson/repos","events_url":"https://api.github.com/users/samwilson/events{/privacy}","received_events_url":"https://api.github.com/users/samwilson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/humanmade/backupwordpress/labels/Bug","name":"Bug","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/humanmade/backupwordpress/milestones/3","html_url":"https://github.com/humanmade/backupwordpress/milestones/Future%20Release","labels_url":"https://api.github.com/repos/humanmade/backupwordpress/milestones/3/labels","id":52671,"number":3,"title":"Future Release","description":"Anything in the Future Release milestone is up for grabs.","creator":{"login":"willmot","id":308507,"avatar_url":"https://avatars.githubusercontent.com/u/308507?v=3","gravatar_id":"","url":"https://api.github.com/users/willmot","html_url":"https://github.com/willmot","followers_url":"https://api.github.com/users/willmot/followers","following_url":"https://api.github.com/users/willmot/following{/other_user}","gists_url":"https://api.github.com/users/willmot/gists{/gist_id}","starred_url":"https://api.github.com/users/willmot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/willmot/subscriptions","organizations_url":"https://api.github.com/users/willmot/orgs","repos_url":"https://api.github.com/users/willmot/repos","events_url":"https://api.github.com/users/willmot/events{/privacy}","received_events_url":"https://api.github.com/users/willmot/received_events","type":"User","site_admin":false},"open_issues":42,"closed_issues":96,"state":"open","created_at":"2011-11-04T10:36:37Z","updated_at":"2015-07-17T17:13:58Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2015-07-02T01:30:41Z","updated_at":"2015-07-18T10:28:59Z","closed_at":null,"body":"With version 3.2.6, I am getting views dumped as tables: the actual view-creation SQL is correct (as in `create view the_view as ...`) but it's preceeded by a `DROP TABLE IF EXISTS the_view` statement, and followed by an attempt to insert data into the view. These statements also can appear *before* the creation of the referenced tables (as it's all alphabetic).\r\n\r\nIt would be great if views could be treated correctly, and probably moved to the end of the dump file (so that it can be assured that their required tables are already in existance).\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/humanmade/backupwordpress/issues/comments/122527602","html_url":"https://github.com/humanmade/backupwordpress/issues/827#issuecomment-122527602","issue_url":"https://api.github.com/repos/humanmade/backupwordpress/issues/827","id":122527602,"user":{"login":"samwilson","id":213655,"avatar_url":"https://avatars.githubusercontent.com/u/213655?v=3","gravatar_id":"","url":"https://api.github.com/users/samwilson","html_url":"https://github.com/samwilson","followers_url":"https://api.github.com/users/samwilson/followers","following_url":"https://api.github.com/users/samwilson/following{/other_user}","gists_url":"https://api.github.com/users/samwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/samwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samwilson/subscriptions","organizations_url":"https://api.github.com/users/samwilson/orgs","repos_url":"https://api.github.com/users/samwilson/repos","events_url":"https://api.github.com/users/samwilson/events{/privacy}","received_events_url":"https://api.github.com/users/samwilson/received_events","type":"User","site_admin":false},"created_at":"2015-07-18T10:28:58Z","updated_at":"2015-07-18T10:28:58Z","body":"@willmot I'd love to have a crack at it; mightn't find time in the short-term though. :( I'll ask the boss! :)\r\n\r\n@pdewouters 5.6 mostly. (I mean, not as in a server is 'slightly 5.5' or anything... ;) Our main servers are at 5.6.)"}}