MySQL Forums
Forum List  »  Data Recovery

Re: mysqldump creates conditional comments that lead to errors when restoring
Posted by: Jochen Kunze
Date: May 23, 2017 05:19AM

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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.