Yes !!! mysqldump -h... -u... -p... mysql > MySQLSchema.sql
Give it a try !!! -----Original Message----- From: Tim McDaniel [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 2:17 PM Cc: mysql@lists.mysql.com Subject: RE: mysql privileges On Wed, 19 Mar 2008, Rolando Edwards <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]