View Single Post

   
  #1 (permalink)  
Old 03-20-2008, 01:47 PM
Tim McDaniel
 
Posts: n/a
Default RE: mysql privileges

On Wed, 19 Mar 2008, Rolando Edwards <redwards@logicworks.net> wrote:
> Yes you will have all the GRANTS for every user sitting in the
> 'mysql' schema (from mysq.user) if you use the --all-databases
> option of mysqldump.


Can I safely assume that dumping the database named "mysql" dumps just
as well as using --all-databases? Our backup script does a mysqldump
for each separate database, and soon will separately dump every table
in every database. (Easier to do a diff when I change just one
table.)

--
Tim McDaniel, tmcd@panix.com
Reply With Quote