Find the answer to your Linux question:
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User
    Join Date
    Apr 2003
    Location
    TEXAS
    Posts
    314

    mysql will not let me load a local file


    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 of mysql.

    I've tried starting my database with this parameter
    Code:
    mysqld_safe --local-infile=1
    I would like to use this feature because the database I'm making will be quite large.
    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)

  2. #2
    Linux 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

  3. #3
    Linux 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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •