MYSQL Options not enabled

Discussion in 'General' started by mphayesuk, Dec 29, 2006.

  1. mphayesuk

    mphayesuk New Member

    I am trying to import a text file into mysql but keep getting the same error

    LOAD DATA LOCAL INFILE '/srv/www/web4/importfile'
    INTO TABLE test_table
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\n' ;

    error 1148

    and when I look this error up I find this:

    http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html

    So is this a misconfiguration when installing ISPConfig + extras....

    Can anyone help with this.

    Thanks
     
  2. Ben

    Ben HowtoForge Supporter

    what tool do you use to execute this query?
    if you use mysql from the cli, try
    use db; source filename;

    maybe it helps to just allow the option in the my.cnf?
     

Share This Page