MySQL - Importing text files

Discussion in 'Server Operation' started by mestedup, Nov 9, 2010.

  1. mestedup

    mestedup New Member

    I am having problems importing text files into MySQL. I have created a table called GSMaster201011 and I have a file on a network drive, called OUPcust_11_06_2010.TXT.

    This is the command I'm using:
    and I get this error:
    From what I can find out, this error means that path is incorrect or MySQL cant access the file. I've checked the path and it is correct, so I checked the permissions and this is what I get when I check the files flags:
    The only problem is I dont know that much about linux and I dont know what I'm looking at with the above query.

    I am logged into locally & MySQL as root.

    Please let me know if you need more information.
  2. mestedup

    mestedup New Member

    I figured it out. I used the "local" option and typed out the path to the file:


Share This Page