How To Solve the LOAD DATA INFILE Error from –secure-file-priv

Author: , June 12th, 2019

The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]

How To Fix An Empty Trash Hang With High CPU Locum On MacOSX

Author: , February 16th, 2011

If you go to empty the Trash on MacOSX and it hangs, check to see if Locum is running and using most of your CPU cycles. If so, you may have the “Empty Trash Securely” option set in Finder Preferences -> Advanced. Uncheck the box and try again… Not sure of the root cause yet, […]