in reply to Load csv file to mysql server
Are you really not getting any error message? You might rename 1.csv for a test to check if the file is accessed at all.
Also you might add a sleep(100); before the query and use a second mysql session with 'show processlist' to see if your script is logged in at all. After running the script you should also see in the mysql logs whether your script was logged in and what command your script was trying to execute
|
|---|