Trying to import into postgres from mysql 5.7 I get 'Killed' as the output in the command line. When I check the database in pgAdmin, it looks like the data is imported, however when I try viewing the rows in the table it says theres no primary keys. Looking into it some more it doesn't look like the primary keys or foreign keys are set. I wouldn't be surprised if I'm missing some configuring somewhere.
The load file I'm using looks like this:
LOAD DATABASE
FROM mysql://[user]:[pass]@localhost/[dbname]
INTO postgresql://[user]:[pass]@localhost/[dbname]
WITH no truncate, create tables, include drop, create indexes, reset sequences, foreign keys, downcase identifiers
SET maintenance_work_mem to '128MB', work_mem to '12MB', search_path to 'public'
CAST type datetime to timestamp drop default drop not null using zero-dates-to-null,
type timestamp to timestamp using zero-dates-to-null,
type date drop not null drop default using zero-dates-to-null,
-- type tinyint to boolean using tinyint-to-boolean,
type year to integer
BEFORE LOAD DO
$$ create schema if not exists public; $$;
Trying to import into postgres from mysql 5.7 I get 'Killed' as the output in the command line. When I check the database in pgAdmin, it looks like the data is imported, however when I try viewing the rows in the table it says theres no primary keys. Looking into it some more it doesn't look like the primary keys or foreign keys are set. I wouldn't be surprised if I'm missing some configuring somewhere.
The load file I'm using looks like this: