--
LOAD DATABASE
FROM mysql://root::like@@SQL!@localhost:3306/egw
INTO postgresql://postgres:mypgpass@localhost:5432/egw
WITH include drop, create tables, create indexes
SET PostgreSQL PARAMETERS
maintenance_work_mem to '128MB',
work_mem to '12MB',
search_path to 'egw, public, "$user"'
CAST type bigint when (= precision 20) to bigserial drop typemod,
type date drop not null drop default using zero-dates-to-null,
type year to integer
BEFORE LOAD DO
$$ create schema if not exists engage; $$;
FATAL error: Failed to open sqlite file #P"/mysql:/root:like@@SQL!!@localhost:3306/egw.load": Could not open sqlite3 database /mysql:/root:like@@SQL!@localhost:3306/egw.load
Code CANTOPEN: no message.
An unhandled error condition has been signalled:
Failed to open sqlite file #P"/mysql:/root:like@@SQL!@172.31.15.13:3306/egw.load": Could not open sqlite3 database /mysql:/root:like@@SQL!@172.31.15.13:3306/egw.load
Code CANTOPEN: no message.
https://github.com/dimitri/pgloader/issues/534#issue-220676817 I have the same issue as in this connection, but I have doubled the @ symbol according to the document and the result remains unchanged. Can you help me take a look at this issue；
-- LOAD DATABASE FROM mysql://root::like@@SQL!@localhost:3306/egw INTO postgresql://postgres:mypgpass@localhost:5432/egw
WITH include drop, create tables, create indexes
SET PostgreSQL PARAMETERS maintenance_work_mem to '128MB', work_mem to '12MB', search_path to 'egw, public, "$user"'
CAST type bigint when (= precision 20) to bigserial drop typemod, type date drop not null drop default using zero-dates-to-null, type year to integer
BEFORE LOAD DO $$ create schema if not exists engage; $$;
FATAL error: Failed to open sqlite file #P"/mysql:/root:like@@SQL!!@localhost:3306/egw.load": Could not open sqlite3 database /mysql:/root:like@@SQL!@localhost:3306/egw.load Code CANTOPEN: no message. An unhandled error condition has been signalled: Failed to open sqlite file #P"/mysql:/root:like@@SQL!@172.31.15.13:3306/egw.load": Could not open sqlite3 database /mysql:/root:like@@SQL!@172.31.15.13:3306/egw.load Code CANTOPEN: no message.