0

Background

I have a script that connects to my MySQL 8 Server and loops through all databases and all tables to export them using mysqldump. I'm doing this as my nightly backup routine and has worked well in the past for previous versions of MySQL.

Problem

Now that I am using a new version of MySQL it seems to fail with the following error message:

Warning: mysqli_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in C:\wamp\www\mysql-backup-new.php

For reference, I am using mysqli within php version 5.5.12 on Windows Server 2012 R2

James
  • 406
  • 1
  • 3
  • 12
  • Can you upgrade PHP, preferably to 7.x? – kmoser Dec 18 '18 at 07:30
  • Please check setting in mysql configuration file and restart mysql service. [client] default-character-set=utf8 [mysql] default-character-set=utf8 – Dipti Dec 18 '18 at 07:31
  • Is that on the server backing up the MySQL server, or the MySQL server itself @Dipti – James Dec 18 '18 at 10:30
  • mysql config file. Refer https://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf-8-in-my-cnf – Dipti Dec 18 '18 at 10:41

0 Answers0