Hi all
Thanks Matt and Kevin, you were right - the /etc/my.cnf had 5 config options in there that
should not have been there for the binary/version I was running.
max_allowed_packet = 16M
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
max_binlog_size
/var/log/mysql/mysql.err didn't show anything, it was /var/lib/mysq/myhostname.err
that I needed to look at. Tailing it as I tried to start the daemon showed each config option
being rejected so I commented them out one-by-one.
The question is why? When apt-get updates a binary and a new config file is needed it should have alerted
me to the changes. Usually Debian saves the old one as my.cnf.org. This put down a production server for
a 1/2 day.
On Thu, Jun 23, 2005 at 05:50:16PM +1000, Michael Lake wrote:
I have a severe problem:
It started with mysqdump not working:
$ mysqldump --add-drop-table kiddev sys_fid
mysqldump: unrecognized option `--max_allowed_packet=16M'
I've hit this problem recently, too. Check /etc/{,mysql/}my.cnf for
"max_allowed_packet" -- most likely you've got it defined in there. I can't
work out why it stopped working sometime recently, either -- I'm thinking
that a Debian woody security update lunched it somehow. It's about the only
distro which still ships MySQL 3.23... <grin>
Is there a more verbose option to start to tell me more info maybe?
I hunted the problems down just by running 'mysqld' at the command line.
It'll spew about 400 lines of crap when it dies -- it's the first line or
two which are interesting. Edit my.cnf to remove that option, run again.
There'll be about 4 directives that will screw it up. When it's running
right, it won't spew at you, it'll just sit there and not drop you back to a
prompt. Run /etc/init.d/mysql restart in another xterm, and it'll all just
There'll be about 4 directives that will screw it up.
--
Mike Lake
Caver, Linux enthusiast and interested in anything technical.
--
UTS CRICOS Provider Code: 00099F
DISCLAIMER: This email message and any accompanying attachments may contain
confidential information. If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments. If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with authority,
states them to be the views the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
