Due to performance issues, I spun up a separate server to install MySql on. I imported it in, adjusted the ip address for the database, and now in my ‘System Check’ I’m getting this error… Does ‘try 2’ succeed? is ‘load data local infile’ working?
Question 2: Do I need to mount the application folder (/opt/matomo) to my database server so it sees it as a local folder?
LOAD DATA INFILE
Using LOAD DATA INFILE will greatly speed Matomo’s archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege.
If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend trying to fix this problem.
Error: LOAD DATA INFILE failed… Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can’t get stat of ‘/opt/matomo/tmp/assets/matomo_option-1ea29a0aa699b75e45d4ea7961ef9469.csv’ (Errcode: 2 - No such file or directory),
Try #2: LOAD DATA LOCAL INFILE :
Troubleshooting: FAQ on matomo.org