problem importing database

[aiman.h.kallaf]

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`)
) 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;

 

[aiman.h.kallaf]

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 ?

 

[aiman.h.kallaf]

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 ?

 

[Jake Bunce]

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

Hmm, I'm not sure. It's possible that it will corrupt the data. It's also possible that it won't make a difference.

I recommend using shell access to restore the backup:

http://xenforo.com/community/resources/how-to-backup-and-restore-your-forum-linux-windows.359/

 

[Jake Bunce]

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 ?

There are many factors that affect performance. Is your server shared or dedicated?

 

[aiman.h.kallaf]

it is shared at www.servage.net

 

[Jake Bunce]

it is shared at www.servage.net

Shared servers have unreliable performance.