PHWinfo - Afficher un message

28/03/2006, 21h23

On Mon, 27 Mar 2006 23:37:21 -0800, Dave <dmehler26@woh.rr.com> wrote:

> is there a way i can do a mysqldump on the databases on machine1, which
> will drop everything needed to recreate them in to a .sql file, transfer
> that to machine2 and then use mysqladmin to load it and have all the
> settings back in business?

The users and privileges are all recorded in the "mysql" database (that
is, a database named "mysql"). You should be able to back this up using
mysqldump on machine1, and restore it on machine2 using the mysql
command-line tool to run the backup as a SQL script.

> I believe they're both mysql4 installs, though machine1 might
> be mysql3.23, not sure.

The schema of the mysql database changes from release to release.
You may need to run the "mysql_fix_privilege_tables" script to upgrade the
schema after you restore it.

See
http://dev.mysql.com/doc/refman/4.1/...ge-tables.html

Regards,
Bill K.

28/03/2006, 21h23	#2
Bill Karwin Messages: n/a Hébergeur:	Re: database permissions On Mon, 27 Mar 2006 23:37:21 -0800, Dave <dmehler26@woh.rr.com> wrote: > is there a way i can do a mysqldump on the databases on machine1, which > will drop everything needed to recreate them in to a .sql file, transfer > that to machine2 and then use mysqladmin to load it and have all the > settings back in business? The users and privileges are all recorded in the "mysql" database (that is, a database named "mysql"). You should be able to back this up using mysqldump on machine1, and restore it on machine2 using the mysql command-line tool to run the backup as a SQL script. > I believe they're both mysql4 installs, though machine1 might > be mysql3.23, not sure. The schema of the mysql database changes from release to release. You may need to run the "mysql_fix_privilege_tables" script to upgrade the schema after you restore it. See http://dev.mysql.com/doc/refman/4.1/...ge-tables.html Regards, Bill K.