Posiadam backup bazy wykonany przez DirectAdmin. Baza ma okolo 500mb.
Próbowalem ją zaimportowac bigdumpem i mysqldumperem lecz podczasz importu pojawia się bład.
Kod
Error at the line 6005: 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'
Query: SET character_set_client = @saved_cs_client;
MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
Na stronie MySQLDuumpera znalazłem:
Cytat
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.
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.
Lecz gdy dodam $comment[]='SET character_set_client = @saved_cs_client;'; na końcu pliku config.php bład podczas importu dalej istnieje. Może mam dodać tą linijke gdzieś indziej ?
Jak zaimportować poprawie tą baze?