LOAD DATA LOCAL problem

[jonleow]

i seem to have a problem with the load data local function.

- i have enable it by using this command: --local-infile[=1]
and i cant load a txt file ex.'pet.txt' into my table called pet. i always get this error : File 'pet.txt' not found (Errcode: 2)



is there anything with the coding above? is my code enabling the load data local wrong?

[aprelium]

jonleow,

Can you please give us more information about the context of this error? What is the script/scripting language you're using?
_________________
Support Team
Aprelium - http://www.aprelium.com

[jonleow]

hi, i created a folder named database and another folder named mysql in my abyss web server dir. I read from the mysql manual that comes together with the download of mysql, that to insert a record into our database table (named 'pet' for my case), we can use the 'load data local' method. In the folder of mysql, there are several other sub folders and one of them is called 'data'. That is where my created database 'menagerie' is stored. So my menagerie database contain one table and that is pet. So i use this coding as described by the manual to load a txt file into it:

mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
i got this error:

File 'pet.txt' not found (Errcode: 2)

[Moxxnixx]

jonleow,
When accessing MySQL, do you have FILE privileges?
The LOAD DATA INFILE statement requires this.

[jonleow]

how do i check whether i have it?

[Moxxnixx]

Easy way to grant privileges - If you have PHPMyAdmin installed, just click on privileges and
look at root user settings.

Alternative way to grant privileges - You must use the GRANT statement. Look here for more info:
http://mysqld.active-venture.com/GRANT.html

[jonleow]

hi MOXXNIXX , i think i will hold on to this problem first and learn the other features of sql. Thanks for the help offered.