Bigdump

[lenney]

i am trying to import a database which i have moved from one host to another but i get this error while using bigdump

Stopped at the line 2626.
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.
Stopped on error




how can i get round this the old server is now offline ?


any other tools please

lenney Reviewed by lenney on 5th Mar 2010. Bigdump i am trying to import a database which i have moved from one host to another but i get this error while using bigdump Stopped at the line 2626. 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. Stopped on error how can i get round this Rating: 5

[GeeZus]

MySQLDumper

Try that.

[lenney]

trying that now just downloaded

[SS-Chris]

You can also ask your host, or, if you have ssh access, to load the sql dump file in through ssh. Doing so through ssh is much faster, and can handle very large databases.

mysql -u username -p -D databasename < dumptextfile.sql

This will ask you for the database password when run. Of course, you must fill in the correct information above.

[lenney]

MySQL says:
Variable 'character_set_client' can't be set to the value of 'NULL'
Error in Query:
SET character_set_client = @saved_cs_client;

with mysqldumper

[GeeZus]

How roughly big is the database?

[lenney]

150mb...

[GeeZus]

Split with this >> " SQLDumpSplitter "

into like 3/4 parts.

[lenney]

cheers mike ill try tommorow cba loggin on pc agen

[lenney]

ssh gave error also

*ERROR at line 3781: Unknown command '\"'.