pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

FATEL error on "SET SQL_MODE = "NO_AUTO_"

Open poudenes opened this issue 2 years ago • 1 comments

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"

poudenes avatar Jun 15 '22 19:06 poudenes

What's the .load file used?

df7cb avatar Jun 27 '22 08:06 df7cb