Server migrated from Percona MySQL 5.7.19 to 5.7.23 failed to apply Load Data infile during replication.
- Master-master replication
- Statement based replication
- Percona MySQL 5.7.23 (both servers)
- CentOS 6.9
Error ‘The MySQL server is running with the --secure-file-priv option so it cannot execute this statement’ on query. Default database: ‘xxxxxx’. Query: ‘LOAD DATA INFILE ‘/var/lib/mysql/SQL_LOAD-597abdb6-26dd-11e8-bac8-f403434e0298-206-1.data’ IGNORE INTO TABLE
xxxxxx FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘’ ESCAPED BY ‘\’ LINES TERMINATED BY ‘\n’ (
The systems were previously running Percona MySQL 5.7.19. We did not experience this problem with that version.
Is this a Percona MySQL 5.7.23 bug?