MySQL Error #1085 - The file '/tmp/<filename>' must be ...

[lpittman]

Since upgrading to 8.1.1 I'm no longer able to import into MySQL via PHPMyAdmin. This is what I am getting:

Error

SQL query:

LOAD DATA INFILE '/tmp/phpiGUgSP' INTO TABLE `members` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said: Documentation
#1085 - The file '/tmp/phpiGUgSP' must be in the database directory or be readable by all

I've checked the permissions of /tmp and its fine - and I've also check my.cnf to make sure it is configured to use /tmp. It had no entries in it (so it was using the system defaults) but added tmpdir=/tmp just to make sure.

It still does not work however - can anyone help me out?

Thanks
Luke

 

[lpittman]

Anyone?

This is fairly urgent - anything would be appreciated.

Luke