{"action":"created","issue":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/359","repository_url":"https://api.github.com/repos/dimitri/pgloader","labels_url":"https://api.github.com/repos/dimitri/pgloader/issues/359/labels{/name}","comments_url":"https://api.github.com/repos/dimitri/pgloader/issues/359/comments","events_url":"https://api.github.com/repos/dimitri/pgloader/issues/359/events","html_url":"https://github.com/dimitri/pgloader/issues/359","id":140740259,"number":359,"title":"can't import mysql schema into postgresql schema differ default schema","user":{"login":"rnz","id":851927,"avatar_url":"https://avatars.githubusercontent.com/u/851927?v=3","gravatar_id":"","url":"https://api.github.com/users/rnz","html_url":"https://github.com/rnz","followers_url":"https://api.github.com/users/rnz/followers","following_url":"https://api.github.com/users/rnz/following{/other_user}","gists_url":"https://api.github.com/users/rnz/gists{/gist_id}","starred_url":"https://api.github.com/users/rnz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rnz/subscriptions","organizations_url":"https://api.github.com/users/rnz/orgs","repos_url":"https://api.github.com/users/rnz/repos","events_url":"https://api.github.com/users/rnz/events{/privacy}","received_events_url":"https://api.github.com/users/rnz/received_events","type":"User","site_admin":false},"labels":[{"id":174483904,"url":"https://api.github.com/repos/dimitri/pgloader/labels/Corner%20case","name":"Corner case","color":"fbca04","default":false},{"id":174483854,"url":"https://api.github.com/repos/dimitri/pgloader/labels/Must%20Fix","name":"Must Fix","color":"eb6420","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-03-14T17:23:53Z","updated_at":"2016-12-07T19:57:40Z","closed_at":"2016-03-20T19:56:20Z","body":"```\nLOAD DATABASE\n     FROM mysql://user:pass@server-mysql/prod\n     INTO postgresql://user:pass@server-pg/dev\n     WITH schema only\n     SET search_path to prod_mysql\n     BEFORE LOAD DO $$ create schema if not exists prod_mysql; $$\n;\n```\n\n```\n$ pgloader mysql-to-pg.load \nAn unhandled error condition has been signalled: At\n\n  LOAD DATABASE\n  ^ (Line 1, Column 0, Position 0)\n\nCould not parse subexpression \";\" when parsing\n\n Expression PGLOADER.PARSER::COMMANDS\n    Subexpression (+ PGLOADER.PARSER::COMMAND)\n    Subexpression PGLOADER.PARSER::COMMAND\n    Subexpression (AND\n                   (OR PGLOADER.PARSER::LOAD-ARCHIVE\n                       PGLOADER.PARSER::LOAD-CSV-FILE\n                       PGLOADER.PARSER::LOAD-FIXED-COLS-FILE\n                       PGLOADER.PARSER::LOAD-COPY-FILE\n                       PGLOADER.PARSER::LOAD-DBF-FILE\n                       PGLOADER.PARSER::LOAD-IXF-FILE\n                       PGLOADER.PARSER::LOAD-MYSQL-DATABASE\n                       PGLOADER.PARSER::LOAD-MSSQL-DATABASE\n                       PGLOADER.PARSER::LOAD-SQLITE-DATABASE)\n                   PGLOADER.PARSER::END-OF-COMMAND)\n    Subexpression PGLOADER.PARSER::END-OF-COMMAND\n    Subexpression (AND PGLOADER.PARSER::IGNORE-WHITESPACE #\\;\n                       PGLOADER.PARSER::IGNORE-WHITESPACE)\n    Subexpression \";\"\n```\n\n```\n$ pgloader --version\npgloader version \"3.2.0\"\ncompiled with SBCL 1.2.4.debian\n```\n\nFile mysql-to-pg.load have not any special/hidden characters.\n"},"comment":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/comments/265555807","html_url":"https://github.com/dimitri/pgloader/issues/359#issuecomment-265555807","issue_url":"https://api.github.com/repos/dimitri/pgloader/issues/359","id":265555807,"user":{"login":"dimitri","id":102900,"avatar_url":"https://avatars.githubusercontent.com/u/102900?v=3","gravatar_id":"","url":"https://api.github.com/users/dimitri","html_url":"https://github.com/dimitri","followers_url":"https://api.github.com/users/dimitri/followers","following_url":"https://api.github.com/users/dimitri/following{/other_user}","gists_url":"https://api.github.com/users/dimitri/gists{/gist_id}","starred_url":"https://api.github.com/users/dimitri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimitri/subscriptions","organizations_url":"https://api.github.com/users/dimitri/orgs","repos_url":"https://api.github.com/users/dimitri/repos","events_url":"https://api.github.com/users/dimitri/events{/privacy}","received_events_url":"https://api.github.com/users/dimitri/received_events","type":"User","site_admin":false},"created_at":"2016-12-07T19:57:40Z","updated_at":"2016-12-07T19:57:40Z","body":"Please upgrade to 3.3.2 that was released recently, I think it fixes your problem here."}}
{"actor":{"display_login":"dimitri"}}