need help with -- unknown variable
am 13.06.2011 18:00:31 von cbrown
--_000_EC4CD3CCC96A0C428D60E8C9DA9596232ADE7B5DD2CMS1bmiorg_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello All ~ I attempted to do a mysqldump when I got this message -- see=
=20below:
mysqldump: unknown variable 'datadir=3D/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.
********************************************
--_000_EC4CD3CCC96A0C428D60E8C9DA9596232ADE7B5DD2CMS1bmiorg_ --
Re: need help with -- unknown variable
am 13.06.2011 18:13:28 von Andrew Moore
--20cf3040e36a2c8e0304a59a33aa
Content-Type: text/plain; charset=ISO-8859-1
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" 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.
> ********************************************
--20cf3040e36a2c8e0304a59a33aa--
RE: need help with -- unknown variable
am 13.06.2011 18:28:13 von cbrown
--_000_EC4CD3CCC96A0C428D60E8C9DA9596232ADE7B5DF1CMS1bmiorg_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello ~ Thanks Andrew - it worked. It worked after I commented it out on=
=20my.cnf file. Any idea what's the purpose of that statement. I inherit=
ed this system.
Thanks all for quick response
[mysqld]
server-id=3D2
relay-log=3Dnaxbmisq04-relay-bin
set-variable=3Dmax_connect_error=3D100
max_allowed_packet=3D1048576000
thread_cache_size=3D16
max_connections=3D200
query_cache_type=3D1
query_cache_size=3D32768000
table_cache=3D800
max_heap_table_size=3D32768000
[mysqldump]
max_allowed_packet=3D1048576000
#datadir=3D/var/lib/mysql
socket=3D/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=3D/var/log/mysqld.log
pid-file=3D/var/run/mysqld/mysqld.pid
From: Andrew Moore [mailto:eroomydna@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 co=
urse it might not be a valid option in mysqldump...I haven't checked...
On 13 Jun 2011 17:00, "Brown, Charles"
com>> wrote:
> Hello All ~ I attempted to do a mysqldump when I got this message -- se=
e below:
>
> mysqldump: unknown variable 'datadir=3D/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.
********************************************
--_000_EC4CD3CCC96A0C428D60E8C9DA9596232ADE7B5DF1CMS1bmiorg_ --