error when mysqldump - Githubissues

go-mysql-org / go-mysql-elasticsearch

Sync MySQL data into elasticsearch

MIT License

4.1k stars 798 forks source link

error when mysqldump #374

Open SunshowerC opened 4 years ago

SunshowerC commented 4 years ago

mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1/!40102 ,SQL_MODE=concat(@@sql_mode, _utf8 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') /': Variable 'sql_mode' can't be set to the value of 'NO_KEY_OPTIONS' (1231) [2020/05/26 06:21:27] [error] canal.go:224 canal dump mysql err: exit status 2 [2020/05/26 06:21:27] [error] river.go:297 start canal err exit status 2

environment: Mac OS, mysql 8.0.12

wenj91 commented 4 years ago

你可以升级你的mysqldump至8.0.14之后的版本，mysqldump --skip-create-options fails on MySQL 8.0 server