Re: mysqldump creates conditional comments that lead to errors when restoring

[Jochen Kunze]

Hello,
no, I do not change anything in the dump file before restoring.
I think you talk about those lines I posted:

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
...
...
...
/*!40101 SET character_set_client = @saved_cs_client */;

The initial "SET @saved_cs_client = @@character_set_client" is there. So the "@@character_set_client" in the first step must be null, so that "@saved_cs_client" becomes null and when trying "SET character_set_client = @saved_cs_client" the error occurs, isn't it?

Is that "@@character_set_client" an environment variable of the MySQL system? I googled it, but didn't find exact information.