Posted by Christoph Burschka on 03/11/07 16:13

Neil Monk wrote:
> Hi,
>
> I'm trying to import an sql file (~22mb) into my 1&1 (business package, uk)
> mysql db.
>
> I don't have ssh access.
>
> I have tried bigdump, but it throws the error:
>
> "Stopped at the line 1019.
> At this place the current query includes more than 300 dump lines. That can
> happen if your dump file was created by some tool which doesn't place a
> semicolon followed by a linebreak at the end of each query, or if your dump
> contains extended inserts. Please read the BigDump FAQs for more infos."
>
> Any ideas anyone please?
>
> I'm a complete newbie to sql and know no php either so I am struggling here.
>
> TIA
>

Just what it says - your SQL dump contains queries that are too long for the
importing tool. If you can make another SQL dump file, try disabling the
"extended inserts" option.

Otherwise, how do you interact with the database anyway? If you don't have shell
access, perhaps there is some tool in your admin panel, like phpMyAdmin? As far
as I know, phpMyAdmin can handle extended inserts. However, if the file is
really 22MB long, you may be hitting the upload limit already.

--
Christoph Burschka <christoph.burschka@rwth-aachen.de>

[Back to original message]