You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi Team, I appreciate your efforts and time to provide such time saving and helpful solution for db migration.
I am migrating from MySQL to PostgreSQL and trying to use the pgloader for the same. However I encountered an error while running the below mentioned script.load file. Could you please assit?
LOAD DATABASE
FROM mysql://user:pass@aws.connect.psdb.cloud/test
INTO postgresql://user:pass@us-east-1.sql.xata.sh/test:main?sslmode=require;
pgloader --version
3.6.9
Output/ERROR
KABOOM!
ESRAP-PARSE-ERROR: At
FROM mysql://user:pass@aws.connect.psdb.cloud/test
INTO postgresql://user:pass@us-east-1.sql.xata.sh/test:main?sslmode=require;
^ (Line 1, Column XXX, Position XXX)
In context COMMAND:
While parsing COMMAND. Problem:
The production
#\:
does not satisfy the predicate ALPHA-CHAR-P.
Expected:
the character Tab
or the character Newline
or the character Return
or the character Space
or the string "--"
or the string "/*"
or the character ; (SEMICOLON)
or the character ? (QUESTION_MARK)
or the string "after"
or the string "alter"
or the string "before"
or the string "cast"
or the string "decoding"
or the string "distribute"
or the string "excluding"
or the string "including"
or the string "materialize"
or the string "set"
or the string "with"
or the character $ (DOLLAR_SIGN)
or the character % (PERCENT_SIGN)
or the character - (HYPHEN-MINUS)
or the character _ (LOW_LINE)
or any character satisfying DIGIT-CHAR-P
or any character satisfying ALPHA-CHAR-P
The text was updated successfully, but these errors were encountered:
Hi Team, I appreciate your efforts and time to provide such time saving and helpful solution for db migration.
I am migrating from MySQL to PostgreSQL and trying to use the
pgloader
for the same. However I encountered an error while running the below mentionedscript.load
file. Could you please assit?pgloader --version
Output/ERROR
The text was updated successfully, but these errors were encountered: