sql restore with error

C

Chris2oo8

New Member
Hello, i tried to restore my sql with bigdump but i get error:

Error at the line 3020: 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'

plz can someone help me, thanx.

PS: if u wanna chat on msn, PM me for my addy kk..
 
edit the sql file and delete that line. It is a variable that was saved with the dump but you don't need it to do the import. You might see some more errors like that, usually the export sets three or four variables depending on how it was configured when you did the initial dump.

hth
 
now i get this error,

Starting from line: 3001

Error at the line 4614: DELIMITER ;;

Query: --
--
DELIMITER ;;


MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 3

im guessing to remove that line too, am gonna try it..
 
omg another one,

Processing file: choco_choco.sql

Starting from line: 3001

Error at the line 4614: DELIMITER ;

Query: --
--
DELIMITER ;


MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 3

i removed that one...
 
Kk there was about 4 or 5 lines I removed, after that the database restored succesfully but vB always says databbase error... gonna restore my whole forum backup now to see if that will fix the problem...
 
Hmm, seems I mentioned that you might find 4 or 5 of them ... LOL

vbulletin database error are intentionally cryptic and meaningless. The message that gets sent to the techie email address has the reason for the error in it.
 
If your database is large you would have problems even with bigdump.

If your hosting has SSH access try importing the database with it it is more reliable and quick method.
 
You must log in or register to reply here.
Back
Top