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?!
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
