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

problem importing database

#1
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​
Code:
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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
 
#2
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 ?
 
#3
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 ?