Re: mysql Etch -> Etch

["Kurian Thayil" <kurianmthayil@gmail.com>]

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, webmaster@worldapart.com <webmaster@worldapart.com> 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 debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact
> listmaster@lists.debian.org
>
>