MySQL ERROR 1193 Unknown system variable GTID_PURGED
When restoring MySQL backup taken on Amazon RDS, i get error
1 2 3 |
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
1 |
SET @@GLOBAL.GTID_PURGED=''; |
Another solution is take a new MySQL backup with –set-gtid-purged=OFF option and restore it.
1 |
mysqldump -u DB_USER -p --set-gtid-purged=OFF --triggers --routines --events DB_NAME > DB_NAME.sql |