hm - bad 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"
Am 05.06.2011 23:26, schrieb ag...@airpost.net: > fwiw, others are seeing this. e.g., in addition to the two bugs i'd > already referenced, > > http://www.directadmin.com/forum/showthread.php?p=202053 > > and one > > > http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command > > claims a solution > > "Add --skip-add-locks to your mysqldump command" > > which, having added as i mentioned above, to the [mysqldump] section of > /etc/my.cnf, does NOT make a difference for me. > > > On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald" > <h.rei...@thelounge.net> wrote: >> the grant statements does nobody interest >> mysql> select * from mysql.user where user='root' limit 1; > > > and, my result for your cmd, > > > mysql> select * from mysql.user where user='root' limit 1; > +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ > | Host | User | Password | > Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | > Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | > Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | > Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | > Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv > | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | > x509_issuer | x509_subject | max_questions | max_updates | > max_connections | max_user_connections | plugin | authentication_string > | > +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ > | localhost | root | *3......................................4 | Y > | Y | Y | Y | Y | Y > | Y | Y | Y | Y | Y | > Y | Y | Y | Y | Y | > Y | Y | Y | Y > | Y | Y | Y | Y > | Y | Y | Y | Y > | Y | | | | > | 0 | 0 | 0 | > 0 | | NULL | > +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ > 1 row in set (0.06 sec) > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 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
signature.asc
Description: OpenPGP digital signature
