Postgres to Mysql?

Kcko's profile image Kcko posted 3 years ago in General Permalink

Hi, i have dump from postgres db (about 130 Mb) and I need to import to MySQL db.

Of course it doesn't work, it has a completely different syntax, is there any easy step to do it in HeidiSQL?

Thx for help.

Kcko's profile image Kcko posted 3 years ago Permalink

See: https://bit.ly/3ntEw0X (transfer between postresql and mysql in heidisql)

Looks like and its bad because this syntax incorrect for mysql (I need strip slahes in table and column names) ...

DROP TABLE IF EXISTS "r5_album_group_rights";
CREATE TABLE IF NOT EXISTS "r5_album_group_rights" (
    "id_album" BIGINT NOT NULL,
    "id_group" BIGINT NOT NULL,
    "rights" BIGINT NOT NULL
);


DELETE FROM "r5_album_group_rights";
INSERT INTO "r5_album_group_rights" ("id_album", "id_group", "rights") VALUES
    (2, 1, 1),
    (3, 1, 1),
    (2, 2, 1),
    (3, 2, 1),
    (19, 2, 1);

How to do that without manually removing slashes?

Please login to leave a reply, or register at first.