Re: mysql Etch -> Etch

["Mariusz Sielicki" <mariusz.sielicki@gmail.com>]

Did you backup database named "mysql" too?
This database contains users and grants data.

Maybe try software for migration: MySQL Migration Toolkit.
http://dev.mysql.com/downloads/gui-tools/5.0.html

Regards.
Mariusz



2008/11/3 webmaster@worldapart.com <webmaster@worldapart.com>:
> 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
>
>