Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th December 2006, 18:45
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default MYSQL Options not enabled

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/...ata-local.html

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

Can anyone help with this.

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 29th December 2006, 18:49
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
 
Default

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?
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 18:37
I'm dying! m u r Installation/Configuration 41 17th September 2006 14:44
MySQL is not enabled in PHP Configure kong121s Installation/Configuration 4 18th May 2006 12:46
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 00:32.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.