Results 1 to 7 of 7
  1. #1
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    I have inserted feeds with phpmyadmin with pipe delimited fields and now today I get this message.

    SQL-query :

    LOAD DATA LOCAL INFILE '/tmp/phpUb5hRS' INTO TABLE `feedlevy` FIELDS TERMINATED BY '|' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

    MySQL said:


    #1148 - The used command is not allowed with this MySQL version



    I dont know if the mysql upgrade or something has to do with anything but I am seriously stuck with this..

    any insite?

  2. #2
    Member Speedy's Avatar
    Join Date
    January 18th, 2005
    Location
    Lancashire UK
    Posts
    165

  3. #3
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    goodness i will never figure that out

    I suppose I have to ask my host to enable it on the server. Just yesterday I will searching around for a dedicated server. I hate the idea of asking and knowing it probably won't be changed..

  4. #4
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    do you think i can write a script that will bypass importing manually like i have previously done?

  5. #5
    ABW Ambassador Jane's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,350
    I had the same problem and they would not enbable it. Finally they told me to try MySQLFront. It works great!
    You can get a copy here

  6. #6
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by jane:
    I had the same problem and they would not enbable it. Finally they told me to try MySQLFront. It works great!
    You can get a copy http://www.mysqlfront.de/ <HR></BLOCKQUOTE>


    Thanks Jane I will try that out!

  7. #7
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    This was the answer to my prayers!! Thanks sooooooooooooo much I like this program and I think it saves alot of time for my projects

  8. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Emergency: Tracking Set Up Issue
    By sherry Ciao in forum ShareASale - SAS
    Replies: 1
    Last Post: June 1st, 2012, 04:57 AM
  2. Emergency Contact for ShareASale?
    By markwelch in forum ShareASale - SAS
    Replies: 3
    Last Post: June 21st, 2009, 10:40 AM
  3. EMERGENCY! Need to restore backup! Please help!
    By kayecee in forum Domains & Hosting
    Replies: 10
    Last Post: August 2nd, 2008, 04:24 PM
  4. emergency broadcast system
    By Pete in forum Introduce Yourself
    Replies: 8
    Last Post: March 10th, 2002, 01:14 PM

Posting Permissions

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