Results 1 to 3 of 3
ever time i execute this command
Code:
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
i get an error that says that this command is not supported with my version ...
- 12-24-2003 #1Linux User
- Join Date
- Apr 2003
- Location
- TEXAS
- Posts
- 314
mysql will not let me load a local file
ever time i execute this command
i get an error that says that this command is not supported with my version of mysql.Code:LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
I've tried starting my database with this parameter
I would like to use this feature because the database I'm making will be quite large.Code:mysqld_safe --local-infile=1
The computer made me do it!! Slackware
and SUSE too Gig\'em WHOOOOP!!
\"God put me on this earth to accomplish a certain amount of tasks, At the rate I\'m going I will never die.\" (I don\'t know)
- 12-24-2003 #2Linux Guru
- Join Date
- Apr 2003
- Location
- London, UK
- Posts
- 3,284
which version of mysql are you running?
alternativly you can copy the file to the server, and use "Load Data infile "filename"" etc etc
- 12-24-2003 #3Linux User
- Join Date
- Apr 2003
- Location
- TEXAS
- Posts
- 314
OK thats was what I was doing wrong. That was what I waws trying to do but I didn't relize that I was trying to upload a local file to the computer I was on rather than the server.
The computer made me do it!! Slackware and SUSE too Gig\'em WHOOOOP!!
\"God put me on this earth to accomplish a certain amount of tasks, At the rate I\'m going I will never die.\" (I don\'t know)
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
