Menu
I'm using mysql 5.5.38 at SMP Debian Linux 3.2.60.
It works fine, but I'm unable to do any backup. mysqldump always shows 'unknown variable "character-set-server=utf-8"' error. i.e.
$ mysqldump --version
unknown variable "character-set-server=utf-8"
Is there any way to fix it in my.cnf or any other way?
404
Replace character-set-server=utf8 or character-set-server=utf8, whichever you have, with default-character-set=utf8 Restart MySQL server. in your ~/.my.cnf or the system-wide my.cnf. This variable isn't recognized and causes an error, so you should remove it.
It is the [client] variable grouping in your config that chokes mysqldump if you don't add the "loose-" prefix to local-infile. Show activity on this post. Seems like the new version you install is compiled without support of local-infile parameter.
The suggestion to comment out the variable is not an option if you want LOAD DATA INFILE functionality out of the box, and MySQL 8+ for security reasons requires you to set this variable for both server (mysqld) and client.
Per documentation https://dev.mysql.com/doc/refman/5.5/en/charset-applications.html ,
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
change character-set-server=utf-8 to character-set-server=utf8 in your my.cnf file
161
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
