I have been having a similar problem with a backup file from a phpBB forum errors keeping showing a syntax error which from what you are all suggesting is the size of the sql, is that correct?
Andrew >-----Original Message----- >From: Stefan Hinz [mailto:[EMAIL PROTECTED] >Sent: 20 March 2003 19:30 >To: Tab Alleman >Cc: [EMAIL PROTECTED] >Subject: Re[4]: Import Batch syntax error > > >Tab, > >>> Are you running this from a script? Maybe it's just a script >>> timeout which would stop with the following line when it gets the >>> timeout: > >> Oops, no sorry for all those who don't know where I left off yesterday >> (tee hee).. This is an import of a .sql file being run from the command >> line like so: > >C:\mysql\bin>>mysql < \dev_hotel_data.sql > >> These things can't timeout, can they? > >No really. But you could hit the communications buffer size (though that >does not seem likely at all with your .sql file). Anyway, it can't >help to try the following: > >C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql > >Regards, >-- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > >[filter fodder: sql, mysql, query] > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.463 / Virus Database: 262 - Release Date: 17/03/2003 > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php