MySQL ERROR 1193 Unknown system variable GTID_PURGED

Written by

When restoring MySQL backup taken on Amazon RDS, i get error

root@PRD-50ml:~# mysql sok_db2 < db.sql
ERROR 1193 (HY000) at line 24: Unknown system variable 'GTID_PURGED'
root@PRD-50ml:~#

To fix this, open db.sql in text editor, remove the line

SET @@GLOBAL.GTID_PURGED='';

Another solution is take a new MySQL backup with --set-gtid-purged=OFF option and restore it.

mysqldump -u DB_USER -p --set-gtid-purged=OFF --triggers --routines --events DB_NAME > DB_NAME.sql

Comments