Jrn 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?

6/21/06, Jrn Dahl-Stamnes <sql01 (AT) dahl-stamnes (DOT) netwrote:
Wednesday 21 June 2006 17:17, Barry wrote:
Jrn 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?!

Hi,

Take the dump using which will give you .txt and .sql file.
Move the dump to the new version of mysql and try using load data infile
'/tmp/user.txt' into table user;

Jrn Dahl-Stamnes wrote:

Thursday 22 June 2006 04:00, Daniel da Veiga wrote:

>
>6/21/06, Jrn Dahl-Stamnes <sql01 (AT) dahl-stamnes (DOT) netwrote:
>
>>
Wednesday 21 June 2006 17:17, Barry wrote:

Jrn 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
--