pgloader
pgloader copied to clipboard
FATEL error on "SET SQL_MODE = "NO_AUTO_"
Hello,
I did a mysql dump normal way and try to convert it. But I get this error:
2022-06-15T17:54:01.054000Z LOG pgloader version "3.6.1"
KABOOM!
FATAL error: At
SET SQL_MODE = "NO_AUTO_
^ (Line 10, Column 0, Position 218)
In context KW-LOAD:
While parsing KW-LOAD. Expected:
the character Tab
or the character Newline
or the character Return
or the character Space
or the string "--"
or the string "/*"
or the string "load"
An unhandled error condition has been signalled: At
SET SQL_MODE = "NO_AUTO_
^ (Line 10, Column 0, Position 218)
In context KW-LOAD:
While parsing KW-LOAD. Expected:
the character Tab
or the character Newline
or the character Return
or the character Space
or the string "--"
or the string "/*"
or the string "load"
What I am doing here?
At
SET SQL_MODE = "NO_AUTO_
^ (Line 10, Column 0, Position 218)
In context KW-LOAD:
While parsing KW-LOAD. Expected:
the character Tab
or the character Newline
or the character Return
or the character Space
or the string "--"
or the string "/*"
or the string "load"
What's the .load file used?