Recent content by javibus

  1. J

    Resolved I can't enable load data infile permanently (losing changes after reboot)

    Solved!! I have created a sql file with a sentence that enables the local infile feature: echo "SET GLOBAL local_infile = 'ON';" > /var/lib/mysql/init_file.sql chown mysql:mysql /var/lib/mysql/init_file.sql And I have configured the mysql service to load this file when it starts by editing the...
  2. J

    Resolved I can't enable load data infile permanently (losing changes after reboot)

    Hello, Thanks for your response. But it throws an error. MariaDB [(none)]> SET PERSIST local_infile = 1; ERROR 1193 (HY000): Unknown system variable 'PERSIST' MariaDB [(none)]> SET @@PERSIST.local_infile = 1; ERROR 1272 (HY000): Variable 'local_infile' is not a variable component (can't be...
  3. J

    Resolved I can't enable load data infile permanently (losing changes after reboot)

    Hello all! I'm going crazy. I need to enable this feature to get Matomo software working smoothly with a high traffic volume. I have configured the db user to get FILE permissions and it works only when I enter into mysql from SSH and run this instruction: SET GLOBAL local_infile = 1; But...
Back
Top