List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:June 13 2011 4:28pm
Subject:RE: need help with -- unknown variable
View as plain text  
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:eroomydna@stripped]
Sent: Monday, June 13, 2011 11:13 AM
To: Brown, Charles
Cc: mysql@stripped
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" <CBrown@stripped<mailto:CBrown@stripped>>
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.
********************************************

Thread
need help with -- unknown variableCharles Brown13 Jun
  • Re: need help with -- unknown variableAndrew Moore13 Jun
    • RE: need help with -- unknown variableCharles Brown13 Jun