Thanks a lot guys. I tried my insert using MYSQL Query Browser and
manage to insert the syslog. Remo, you're correct, the Windows Command
prompt limitation is the cause since i'm using windows xp cmd.exe.
I'll try to do import as you've suggested.
What a relief, i can proceed in building my syslog database.
Thanks again. You guys are the BEST!
Liz
On 8/11/05, Remo Tex <[EMAIL PROTECTED]> wrote:
> Liz you didn't mention by I suppose you're using Windows client too i.e.
> mysql.exe. A quick test revealed that in such a case char limit is <=255
> i.e. that's limitation of Windows Command Prompt: command.com or in case
> of Win NT,2000,XP - cmd.exe
> try writing your long SQL command in text file and import from there ;-)
> try:
> mysql (your host, login etc. options here ) < import.sql
> or from within mysql prompt> source import.sql;
>
> HTH
>
> Elizabeth Bonifacio wrote:
> > Dear Guys,
> >
> > Can please anyone advice me how to successfully insert long text data
> > into my innodb table rawlog with table stucture as follows:
> > mysql> desc rawlog;
> > +-------+----------+------+-----+---------+-------+
> > | Field | Type | Null | Key | Default | Extra |
> > +-------+----------+------+-----+---------+-------+
> > | log | longtext | YES | | NULL | |
> > +-------+----------+------+-----+---------+-------+
> > 1 row in set (0.03 sec)
> >
> > here is one sample of the syslog data I'm trying to insert into the
> > table without success:
> >
> > insert into rawlog values ('<133>date=2005-07-25 time=12:38:23
> > device_id=FGT1002105200379 log_id=0022010001 type=traffic
> > subtype=allowed pri=notice vd=root SN=1321 duration=180 policyid=1
> > proto=17 service=29716/udp status=accept src=192.168.2.63
> > srcname=192.168.2.63 dst=193.11.28.37 dstname=193.11.28.37
> > src_int=internal dst_int=external sent=46 rcvd=86 sent_pkt=1
> > rcvd_pkt=1 src_port=10055 dst_port=29716 vpn=n/a tran_ip=202.189.48.98
> > tran_port=43957 dir_disp=org tran_disp=noop');
> >
> > I've already tried changing my column data type from varchar to text
> > types but still the insert statement cannot be typed all the way to
> > the end of statement.I can only type half of the syslog data. Does it
> > has something to do
> > with my system? I'm using mysql version 4.1.11 running in windows xp
> > 32 bit. My max_allowed_packet is 1048576, do I need to increase this?
> > by how much?
> >
> > Please advice me as a need to insert lots of long syslog data in this table.
> > All the best.
> >
> > Elizabeth
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
