Hi, You can get the mysqldump from the Machine A and then restore this dump in new MySQL installation @ Machine B.
Machine A: mysqldump -u root --all-databases>all-database_1.sql port this mysqldump (all-database_1.sql) to Machine B and run the command from dump's saved location. Machine B: mysql -u root <all-database_1.sql Regards, Kurian Mathew Thayil. On 11/3/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi all, > > I want to move all mysql databases with all users, grants, etc. from one > box (Etch) to another (Etch). > > One box 1: > tar czvf /backups/varlibmysql.tgz /var/lib/mysql > > One box 2: > /etc/init.d/mysql stop > cd / > tar zxvf /backups/varlibmysql.tgz > /etc/init.d/mysql start > > This way i'm missing users, grants, etc. > > Help please. > > Thanks in advance. > > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact > [EMAIL PROTECTED] > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
