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
Tab,
>> file). Anyway, it can't help to try the following:
>> C:\mysql\bin>>mysql --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 diffe
2003 10:51 AM
Subject: Import 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
h 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
>>
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\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
>
> Regards,
Thanks, I'll try th
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
Stefan Hinz wrote:
>
> 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 th
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
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 th
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
10 matches
Mail list logo
