Rank Amateur Back for More

[Stephen Tiano]

Okay, I found User Comments at the end of the section of the user manual online that contained the info I needed to get the option of loading a textfile into a table.

The startup line I use for that is:

/usr/local/bin/mysql -u root --local-infile -p menagerie

where 'menagerie' is the database that has the table into which I want to load data.

Observation: I guess there's no way to just give myself a 'free pass' to be able to load data into any database. It appears I have to name a particular database right at the start.

Anyway ... Then, of course, I do a

USE menagerie

Now I want toL in the textfile called pet.txt, which I downloaded from the MySQL website at http:.//www.mysql.com/Downloads/Contrib/Examples/menagerie.zip, into the table pet which now resides in my Sites folder. So I issue the command

LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

and, for the first time, I am not denied LOADing DATA privileges. I do, however, get to read:

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

What's up with that? I checked the folder 'menagerie' in the Sites folder. pet.txt is most definitely there, and it contains comma delimited rows to go with the tutorial table I'm working at.

But it'd sure help top know what's going on now with trying to load data from a textfile.

Steve Tiano


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php