From: Reindl Harald
Date: June 5 2011 8:24pm
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/225164
Message-Id: <4DEBE60F.2020602@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig3F5775E9F42C505E4C6EA174"

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

have you checked you permissions-table if all privileges are active for r=
oot
and have you started "ymsql_upgrade" after all updates?

Am 05.06.2011 22:20, schrieb agd85@stripped:
> i use ZRM to do backups of my databases.
>=20
> with v5.1.x, this works fine,
>=20
>   mysql-zrm-scheduler --now --backup-set manual --backup-level 0
>=20
> to execute a manual backup.
>=20
> i recently upgraded from v5.1.x -> v5.5.12,
>=20
>  mysqladmin -V
>   mysqladmin  Ver 8.42 Distrib 5.5.12, for Linux on i686
>=20
> now, at exec of that backup cmd, i see an ERROR @ console,
>=20
> 	...
> 	manual:backup:INFO: PHASE START: Creating raw backup
> 	manual:backup:INFO: Command used for raw backup is
> 	/usr/share/mysql-zrm/plugins/socket-copy.pl
> 	--mysqlhotcopy=3D/usr/bin --host=3D"localhost" --port=3D"3306"
> 	--socket=3D"/var/cache/mysql/mysql.sock" --quiet  mysql=20
> 	"/var/mysql-bkup/manual/20110605131003" >
> 	/var/cache/tmp/bZvaQFwQY2 2>&1
> 	manual:backup:INFO: raw-databases=3Dmysql
> 	manual:backup:INFO: PHASE END: Creating raw backup
> 	manual:backup:INFO: PHASE START: Creating logical backup
> 	manual:backup:WARNING: The database(s) drupal6
> 	performance_schema will be backed up in logical mode since they
> 	contain tables that use a transactional engine.
> 	manual:backup:INFO: Command used for logical backup is
> 	"/usr/bin"/mysqldump --opt --extended-insert --create-options
> 	--default-character-set=3Dutf8 --routines --host=3D"localhost"
> 	--port=3D"3306" --socket=3D"/var/cache/mysql/mysql.sock" --databases
> 	drupal6 performance_schema  >
> 	"/var/mysql-bkup/manual/20110605131003/backup.sql"
> 	mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to
> 	user 'root'@'localhost' for table 'cond_instances' when using
> 	LOCK TABLES
> -->     manual:backup:ERROR: mysqldump did not succeed.
> 	 Command used is "/usr/bin"/mysqldump --opt --extended-insert
> 	 --create-options --default-character-set=3Dutf8 --routines
> 	 --host=3D"localhost" --port=3D"3306"
> 	 --socket=3D"/var/cache/mysql/mysql.sock" --databases drupal6
> 	 performance_schema  >
> 	 "/var/mysql-bkup/manual/20110605131003/backup.sql"manual:backup:INFO:=

> 	 PHASE START: Cleanup
> 	manual:backup:INFO: backup-status=3DBackup failed
> 	...
>=20
>=20
> reading up on the error at,
>=20
>  http://bugs.mysql.com/bug.php?id=3D33762
>  http://bugs.mysql.com/bug.php?id=3D49633
>=20
> it looks to do with mysqldump itself.  i modified in /etc/my.cnf
>=20
> 	...
> 	[mysqldump]
> 	quick
> 	quote-names
> 	max_allowed_packet =3D 8M
> +       skip-lock-tables
> 	...
>=20
> but that doesn't seem to make any difference.
>=20
> something's changed between 5.1.x & 5.5.x.
>=20
> what do i need to modify to get past this error?
>=20

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


--------------enig3F5775E9F42C505E4C6EA174
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/

iEYEARECAAYFAk3r5g8ACgkQhmBjz394AnlRxACbBu7z2Q/Rr3if5eSgz+u9kB3T
desAnjPLha/fnmMZb9tr/KSi2AHDAcu8
=GeWe
-----END PGP SIGNATURE-----

--------------enig3F5775E9F42C505E4C6EA174--