I'm trying to import data with the mysqlimport tool and it gives me the following error:
mysqlimport: Error: 1290, The MySQL server is running with the --secure-file-priv option so it can not execute this statement, when using table: City
I have modified the /etc/my.cnf file to indicate on the secure-file-priv line that the backup copies are in the / backups folder.
It does not work with mysqlimport or with LOAD DATA.
Does anyone have any idea what it can be?