I get the following error when I try to use mysqlcheck
, mysqlrepair
or mysqlanalyze
:
mysqlcheck: unknown variable 'max_allowed_packet=100M'
I am trying to find whether there are any corrupt tables or indexes.
Background:
- MySQL Ver 14.14 Distrib 5.5.24, for Linux (x86_64) using readline 5.1
- I used the command
mysqlcheck -u xxxx -h xxx.xxx.xx.xx -d xxxx -p xxxxx
my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set = utf8
max_allowed_packet = 100M
Under [client]