Hello ~ Thanks Andrew - it worked. It worked after I commented it out on my.cnf file. Any idea what's the purpose of that statement. I inherited this system.
Thanks all for quick response [mysqld] server-id=2 relay-log=naxbmisq04-relay-bin set-variable=max_connect_error=100 max_allowed_packet=1048576000 thread_cache_size=16 max_connections=200 query_cache_type=1 query_cache_size=32768000 table_cache=800 max_heap_table_size=32768000 [mysqldump] max_allowed_packet=1048576000 #datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Monday, June 13, 2011 11:13 AM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: need help with -- unknown variable Check if this is in the [mysqldump] section of your my.cnf file(s). Of course it might not be a valid option in mysqldump...I haven't checked... On 13 Jun 2011 17:00, "Brown, Charles" <cbr...@bmi.com<mailto:cbr...@bmi.com>> wrote: > Hello All ~ I attempted to do a mysqldump when I got this message -- see > below: > > mysqldump: unknown variable 'datadir=/var/lib/mysql' > > Please can someone help me. > > Thanks > > > > > > ******************************************** > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > ******************************************** ******************************************** This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. ********************************************