From: Reindl Harald
Date: June 5 2011 9:52pm
Subject: Re: upgraded from 5.1->5.5.  now getting a mysqldump ERROR "1142:
 SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'
 when using LOCK TABLES".  a bug or my config?
List-Archive: http://lists.mysql.com/mysql/225173
Message-Id: <4DEBFAA0.4040403@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig7A7BCE85AFE8E10FBC5409B1"

--------------enig7A7BCE85AFE8E10FBC5409B1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 05.06.2011 23:49, schrieb agd85@stripped:
>=20
> On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
> <h.reindl@stripped> wrote:
>> i would use a replication slave and stop him for consistent backups
>> because dumb locks are not really a good solution independent
>> if this works "normally"
>=20
> unfortunately, i have no idea what that means.
>=20
> something's apparently broken with mysqldump -- enough so that lots of
> people are seeing and reporting this same error after the 5.1 -> 5.5
> upgrade.
>=20
> why would setting up a replication slave be necessary or a good solutio=
n
> to the problem?

because there is no lock on any production table?
have fun using mysqldump with really hughe databases :-)

a replication slave is synchron, you can stop the slave, copy
the whole datadir and after starting the slave it will
make all changes from the binary log


--------------enig7A7BCE85AFE8E10FBC5409B1
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3r+qAACgkQhmBjz394AnmjWwCfa8LWXmXCaK473gGf8UA2cnPw
u50An3+3jeOvYCObN2EvGw7CFltaMq3G
=J9gH
-----END PGP SIGNATURE-----

--------------enig7A7BCE85AFE8E10FBC5409B1--