Is it possible that when you try to import a backup of your MySQL database on Google Cloud, you have the following error :
![](https://nicolasbaptista.com/wp-content/uploads/2024/02/image-5.png)
![](https://nicolasbaptista.com/wp-content/uploads/2022/01/image-15-1024x89.png)
error: exit status 1 stdout(capped at 100k bytes): stderr: ERROR 3546 (HY000) at line 26: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED
To solve the problem, open the SQL file with text editor and search the error “@@GLOBAL.GTID_EXECUTED”
![](https://nicolasbaptista.com/wp-content/uploads/2022/01/image-14-1024x161.png)
After modifying the *.sql file, you should be able to import successfully :
![](https://nicolasbaptista.com/wp-content/uploads/2022/01/image-16.png)
0 Comments