i have mysql and postgress servers on linux on same machine, im migrating mysql database to postgress by using pgloader below is my script im using.
LOAD DATABASE
FROM mysql://master:[email protected]:3306/naqaba_portal
INTO postgresql://postgres:[email protected]:5432/pg_gsc_v2
WITH include no drop, create tables, create indexes, reset sequences, data only;
but it is giving an error im sharing it below.
root@WOQOOF:~# pgloader migrate.load
2024-07-06T08:07:50.008000+08:00 LOG pgloader version “3.6.2”
2024-07-06T08:07:50.100003+08:00 LOG Migrating from #<MYSQL-CONNECTION mysql://[email protected]:3306/naqaba_portal {1007FAB923}>
2024-07-06T08:07:50.100003+08:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://[email protected]:5432/pg_gsc_v2 {1007FAC643}>
KABOOM!
FATAL error: pgloader failed to find anything in schema “naqaba_portal” in target catalog.
An unhandled error condition has been signalled:
pgloader failed to find anything in schema “naqaba_portal” in target catalog.
it says it is not able to find anything in the target schema, I created a dataase in postgress and created schema but it was supposed to migrate mysql database into postgress database it was supposed to create tables and move data by it self. but it is not migrating at all instaed giving this error. If there is any way i can migrate it so my sql database should be replicated in postgress please help.
i have double checked schema is created postgress is running i have given all previlidges to the schema but still having this error.