Latest Announcemnent
New thread

Bigdump

Status
Not open for further replies.
L

lenney

Active Member
669
2008
1
0
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
 
23 comments
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.

Code: 
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.
 
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
 
lenney said:
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
Click to expand...

Open up bigdump.php and look for the following
Code: 
define ('MAX_QUERY_LINES',300);      // How many lines may be considered to be one query (except text lines)

Replace 300 with a higher number.
 
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
 
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?
 
Open with a good editor something in the lines of Notepad2 or so. Remove that line, hopefully, that will help.
 
Status
Not open for further replies.
Back
Top