Tab,
file). Anyway, it can't help to try the following:
C:\mysql\binmysql --max-allowed-packet=32M \dev_hotel_data.sql
Thanks, I'll try that... But in the meantime, is there something I can
do to get Mysql to show me more information about the syntax error? I
think that the difference in
Gerald R. Jensen wrote:
I just ran your query (create and both inserts), and it
worked like a charm on a Win32 MySQL 3.23.52.
Just out of curiousity, why are putting the \r in?
Gerald (and all who were interested),
I didn't put the \r in, actually...mysqldump did. The solution to the
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces the error:
INSERT
On Thursday 20 March 2003 18:51, Tab Alleman wrote:
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that
Tab,
On Thursday 20 March 2003 18:51, Tab Alleman wrote:
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with
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
Stefan Hinz wrote:
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\binmysql --max-allowed-packet=32M \dev_hotel_data.sql
Regards,
Thanks, I'll try that... But
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
Batch syntax error
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces