Connecting Tech Pros Worldwide Forums | Help | Site Map

How to store big amount of data in long text field

Newbie
 
Join Date: Mar 2007
Posts: 4
#1: Mar 18 '07
I need to use MySql to store really large amounts of data . but
when i try to store ,text file in long text field with LOAD_FILE command,
the error i got was like :
"Data too long for column <longtext field name>"
Please help me.

bartonc's Avatar
Moderator
 
Join Date: Sep 2006
Location: Minden, Nevada, USA
Posts: 6,400
#2: Mar 18 '07

re: How to store big amount of data in long text field


Quote:

Originally Posted by sadf

I need to use MySql to store really large amounts of data . but
when i try to store ,text file in long text field with LOAD_FILE command,
the error i got was like :
"Data too long for column <longtext field name>"
Please help me.

I'm guessing that the file is not over 4 gig, so which engine are you using on this DB?
bartonc's Avatar
Moderator
 
Join Date: Sep 2006
Location: Minden, Nevada, USA
Posts: 6,400
#3: Mar 18 '07

re: How to store big amount of data in long text field


Quote:

Originally Posted by bartonc

I'm guessing that the file is not over 4 gig, so which engine are you using on this DB?

Also showing the syntax of your loadfile command would be very helpful. Thanks.
Reply