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

 

[StupidGlitch]

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

 

[StupidGlitch]

How roughly big is the database?

 

[lenney]

150mb...

 

[StupidGlitch]

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 '\"'.

 

[c0rrupt]

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

Open up bigdump.php and look for the following

define ('MAX_QUERY_LINES',300);      // How many lines may be considered to be one query (except text lines)

Replace 300 with a higher number.

 

[lenney]

tried that and got this lol

Error at the line 3011: SET character_set_client = @saved_cs_client;
Query: SET character_set_client = @saved_cs_client;
MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
Stopped on error

gets better

 

[Festus]

don't check "Extended inserts" when you backup you db from phpmyadmin, then it works

 

[rapid-ddldotcom]

i think you need to use mysql dumper its better then bigdump

 

[lenney]

don't check "Extended inserts" when you backup you db from phpmyadmin, then it works

you have not read page one

i think you need to use mysql dumper its better then bigdump

you also have not read page one

 

[SS-Chris]

Are the MySQL versions the same from the host you backed up from to the new host you are trying to import to? What does line 3781 show?

 

[lenney]

yes they are the same version

and i have no idea how to open the file with it being so big to find that line

 

[Dman]

Open with a good editor something in the lines of Notepad2 or so. Remove that line, hopefully, that will help.

 

[lenney]

too big to open with notepad2 takes for ever then just crashes

 

[Whoo]

Open up the SQL file with Wordpad =]