Hello,
I am trying to migrate to a new installation with AWS RDS as my database (which I have already been using for years). The problem with RDS is the lack of the SUPER privilege and the way mysqldump works when invoked via Plesk. My dumps have some lines that cause problems:
It seems that mysqldump is called with --no-defaults option, so I don't know how to override these parameters. I would probably need to set "--set-gtid-purged=OFF", but I don't know where to place it.
Is there a way I can proceed? I cannot think of moving all databases by hand.
Best regards.
I am trying to migrate to a new installation with AWS RDS as my database (which I have already been using for years). The problem with RDS is the lack of the SUPER privilege and the way mysqldump works when invoked via Plesk. My dumps have some lines that cause problems:
Code:
SET @@SESSION.SQL_LOG_BIN= 0;
SET @@GLOBAL.GTID_PURGED='';
It seems that mysqldump is called with --no-defaults option, so I don't know how to override these parameters. I would probably need to set "--set-gtid-purged=OFF", but I don't know where to place it.
Is there a way I can proceed? I cannot think of moving all databases by hand.
Best regards.