URL "/mysql/list-all-columns.sql" not found!

[ghost]

Hello, when I migrated from mysql to PG using pgloader, I returned an error like this: URL "/mysql/list-all-columns.sql" not found! Do you know what is going on?I confirm that the command is correct and can connect to the database.

2019-05-10T09:54:30.483000Z ERROR mysql: URL "/mysql/list-all-columns.sql" not found!

[dimitri]

Which version of pgloader are you using? I can't reproduce here from current master's version.

[kohanis]

Same. Current head, builded on windows with latest msys2

[dimitri]

Strange. The URL thing is an internal facility used in pgloader source code to embed SQL files found in the repository right in the pgloader binary. That happens at compile time. It seems that it didn't happen for you for some reasons? Maybe the src/utils/queries.lisp as shown below isn't compatible with a windows build, in which case we'll need to fix it.

Do you have a log of the pgloader build?

Check out the following files for the implementation I'm referring to:

https://github.com/dimitri/pgloader/blob/master/src/utils/queries.lisp
https://github.com/dimitri/pgloader/tree/master/src/sources/mysql/sql

To help me fix pgloader on windows, I need an environment where I can work. Can you tell me how you made it possible to compile pgloader windows? Last I tried I could not find a version of the FreeTDS DLL library for windows, the infamous sybdb.dll... and that's been a show-stopper for me.

[w93163red]

@dimitri I met the same problem. This occurs when compiled with SBCL. I have posted the file which requires on #652