GRANT SELECT, LOCK TABLES ON dbname.* TO dump@'%' IDENTIFIED BY 'dump'; mysqldump --opt -udump -pdump -hlocalhost -B dbname --tables table_name
worked just fine for me. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/27/04, 1:40:46 PM, Paul DuBois <[EMAIL PROTECTED]> wrote regarding Re: Minimum privileges required for mysqldump: > At 11:37 -0800 2/27/04, Jim Shea wrote: > >At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: > >>Give the use the lock option if you plan on using the --opt. > > > >How is that different than > > > >> > Giving the "lock tables" permission as in: > >>> grant select, lock tables on dbname.* to [EMAIL PROTECTED]; > >> > >>> results in the same mysqldump error. > > > >in the previous message? > > > >Jim > Well, for one thing, the grant table is specific, whereas the meaning > of "the lock option" is somewhat unclear. :-) > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > MySQL Users Conference: April 14-16, 2004 > http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
