On Thursday 22 June 2006 04:00, Daniel da Veiga wrote: > On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: > > On Wednesday 21 June 2006 17:17, Barry wrote: > > > Jørn Dahl-Stamnes schrieb: > > > > Is it possible to get mysqldump to include rights that has been > > > > GRANTED to a database or to tables in the database that is being > > > > dumped? > > > > > > Dump the Grant tables? > > > > I have though of it. Currently I am dumping the mysql database, but there > > is a lot of tables that I probably don't need. > > > > Based on a dump of the mysql database, I guess that the following tables > > are the one I need to dump: > > > > mysql.db > > mysql.table_privs > > mysql.user > > > > Comments? > > Isn't the "hosts" table needed too?!
Maybe, but it is empty on my sql-server. BTW, I'm using an older version of MySQL: -- MySQL dump 10.9 -- -- Host: localhost Database: mysql -- ------------------------------------------------------ -- Server version 4.1.8-standard -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]