• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

problem importing database

I'm just testing one of the backup to check if it is work on my local host using bigdump

i got this error and it stopped importing !

Processing file: FORUM5a64d.sql
Starting from line: 15006
Error at the line 15014: 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
these are few lines before and after the error​
SET @saved_cs_client    = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xf_moderation_queue` (
  `content_type` varchar(25) NOT NULL,
  `content_id` int(10) unsigned NOT NULL,
  `content_date` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`content_type`,`content_id`),
  KEY `content_date` (`content_date`)
[COLOR=#008000]SET character_set_client = @saved_cs_client;[/COLOR]
-- Dumping data for table `xf_moderation_queue`
-- Table structure for table `xf_moderator`
SET @saved_cs_client    = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xf_moderator` (
  `user_id` int(10) unsigned NOT NULL,
  `is_super_moderator` tinyint(3) unsigned NOT NULL,
  `moderator_permissions` mediumblob NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL,
  PRIMARY KEY (`user_id`)
SET character_set_client = @saved_cs_client;
I find an answer

Q: I get an error: “MySQL: Variable ‘xyz’ can’t be set to the value of ‘NULL’”. Why?
A: Your dump file probably contains a statement like this: SET character_set_client = @saved_cs_client; Bigdump is not able to restore settings saved at the beginning of the import process. However you can skip this error message by adding a comment setting $comment[]='SET character_set_client = @saved_cs_client;'; to the BigDump configuration.

the question now will this shave any impact at the forum ?
another question

i imported the database to my localhost successfully and the forum work as the speed of light which is not the case on the server , that this mean the problem from the server which my forum is hosted at ?