Tnx for the help.
The problem was indeed the missing ; after every statement, but even then
phpMyAdmin would mess up. Free Mascan did the trick however (after I
inserted the ;'s).
tnx again.
Johan
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 27, 2001 6:36 PM
Subject: Re: Problem with huge sql-dump
>
> Are the statements ended properly?
>
> like...insert into table (values etc);
>
> Some db's will dump with no semicolon on the end...will give you
> an error on the second line.
>
> eejack
> 091120010850
>
>
>
> At 06:28 PM 10/27/01 +0200, Johan Nagels wrote:
> >Hi,
> >
> >I'm trying to import a huge SQL-dump (generated by another program). The
> >statements are correct because if I excute them one-by-one no error is
> >generated. However if I upload them all at once (thru phpMyAdmi or Free
> >Mascon) I always get an error somewhere at te second line.
> >Btw. in the dump there are 4040 insert-statements, all about 450 chars
wide
> >=> the file is more than 1.8 Mb big.
> >
> >Can anybody help me with this asap, coz my boss is waiting...
> >
> >tnx,
> > Johan
> >
> >
> >---------------------------------------------------------------------
> >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
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
