Very intresting problems on mysql database

Hello all,
my problem is here

i download zip files from another url to my server. Then extract zip files into datewise folder. zip files contains three csv data files. each file contains minimum 80000 to 150000 thousand records. i want to create dynamic table datewise & insert that csv into created table. for that i use LOAD DATA INFILE mysql command . It works fine on my local machine but i want to insert database on server.

let me tell what i completed .
i download zip files & store in date wise folder on server. then extract into datewise folder. but when i try to import that csv files i comes error file path not found.


/user/local/apache/htdocs/~username/datewisefoldername/extract_foldername


so tell me how should i use LOAD DATA FILE command or there is any other solution .

I trying for from last 2 weeks but not found solution. On my local machine it works fine but on server it's not.

please give me solution ASAP.

Thanks in advance..........

 

oh never dont have this problem

 

You only have the path problem or mysql does not have rights to read the directory.

 

You should check mysql documentation (dev.mysql.com/doc/refman/5.0/en/load-data.html) related to this issue.

 

there is possible problem with permission issues. You have to check if folder has permission. Also, make sure if your mysql username has permission for LOAD DATA FILE.