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

problem importing database

Discussion in 'XenForo Questions and Support' started by aiman.h.kallaf, Sep 7, 2012.

  1. aiman.h.kallaf

    aiman.h.kallaf Active Member

    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. aiman.h.kallaf

    aiman.h.kallaf Active Member

    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 ?
     
    Jake Bunce likes this.
  3. aiman.h.kallaf

    aiman.h.kallaf Active Member

    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 ?
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    aiman.h.kallaf likes this.
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    There are many factors that affect performance. Is your server shared or dedicated?
     
    aiman.h.kallaf likes this.
  6. aiman.h.kallaf

    aiman.h.kallaf Active Member

  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Shared servers have unreliable performance.
     
    aiman.h.kallaf likes this.

Share This Page