Having issues with mysql to postgres migration with pgloader

[shaileshmistri22]

Receiving below error :-

postgres@zammadpostgres:$ pgloader zammad.load
2025-07-15T13:43:01.014000Z LOG pgloader version "3.6.10devel"
KABOOM!
ESRAP-PARSE-ERROR: At

LOAD SQL FILE

^ (Line 1, Column 0, Position 0)

In context COMMAND:

While parsing COMMAND. 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 "archive"
or the string "copy"
or the string "csv"
or the string "database"
or the string "dbf"
or the string "fixed"
or the string "ixf"
An unhandled error condition has been signalled: At

LOAD SQL FILE

^ (Line 1, Column 0, Position 0)

In context COMMAND:

While parsing COMMAND. 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 "archive"
or the string "copy"
or the string "csv"
or the string "database"
or the string "dbf"
or the string "fixed"
or the string "ixf"

What I am doing here?

At

LOAD SQL FILE

^ (Line 1, Column 0, Position 0)

In context COMMAND:

While parsing COMMAND. 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 "archive"
or the string "copy"
or the string "csv"
or the string "database"
or the string "dbf"
or the string "fixed"
or the string "ixf

Inspite i tried to use docker for higher version of pgloader but still getting same error

[isaacvicente]

Hi,

I'm having a similar error.

Pgloader version (using Docker image ghcr.io/dimitri/pgloader:latest):
pgloader version "3.6.10~devel"
compiled with SBCL 2.2.9.debian

Context: I'm trying to migrate a Mattermost database on MySQL to PosgreSQL using the official Mattermost documentation. On Step 4 - Run pgloader, I got the error:

2025-09-29T15:31:05.048000Z LOG pgloader version "3.6.10~devel"
KABOOM!
ESRAP-PARSE-ERROR: At

  WITH data only,
      workers = 8, concurrency = 1,

                                  ^ (Line 6, Column 32, Position 218)

In context SQLITE-OPTIONS:

While parsing SQLITE-OPTIONS. 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 "batch"
  or the string "concurrency"
  or the string "create"
  or the string "data"
  or the string "disable"
  or the string "downcase"
  or the string "drop"
  or the string "encoding"
  or the string "foreign"
  or the string "include"
  or the string "max"
  or the string "no"
  or the string "on"
  or the string "prefetch"
  or the string "preserve"
  or the string "quote"
  or the string "reset"
  or the string "schema"
  or the string "snake_case"
  or the string "truncate"
  or the string "uniquify"
  or the string "workers"

For reference, my .load file is in this pastebin.

It seems that pgloader is treating the MySQL connection as a SQLite connection and uses it's syntax, resulting in the syntax error.

There's a old closed issue #1048 related to this, it might be back.
Any feedback?

[isaacvicente]

Update:

Got it working by passing the flag --type mysql. Still it should work without the flag.