Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Postgres to Mysql?

Kcko's profile image Kcko posted 5 days 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 5 days 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.