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 ISPConfig Developer ISPConfig Developer

    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