Search code examples
mysql

ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'

I took backup of database from workbench from a remote server. So when I import it on my local environment I got error:

ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'

I'm using xampp server

Getting same error either import db via console or phpmyadmin

Solution

  • After spending a lot of time.

    I opened my database file in text editor and search for this variable "GLOBAL.GTID_PURGED". I just set it's value ""

    like

    SET @@GLOBAL.GTID_PURGED=""

    Then I upload database via windows console now It works like a charm :)