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.
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.
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.