Results 1 to 3 of 3

Thread: Load MySQL Database with Text file

  1. #1
    testbank is offline Junior Member
    Join Date
    Sep 2014
    Posts
    2

    Default Load MySQL Database with Text file

    Hello,
    I just got my website yesterday and I am new to this whole thing. I have a text file which was produced from an excel spreadsheet. The fields are separated by tabs. I went into phpmyadmin and created a table with the same number of columns as my text file. When I try and use the LOAD DATA LOCAL INFILE function in the SQL tab it says that this is not an acceptable function. Can someone explain what I am doing wrong?

  2. #2
    testbank is offline Junior Member
    Join Date
    Sep 2014
    Posts
    2

    Default

    Now this is the error I'm getting:

    #1045 - Access denied for user 'testbank'@'localhost' (using password: NO)

  3. #3
    Gianluca is offline Administrator
    Join Date
    Feb 2010
    Posts
    512

    Default

    testbank:

    unfortunately LOAD DATA LOCAL INFILE is not available.

Tags for this Thread

Posting Permissions

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

SEO by vBSEO