Re: mysql Etch -> Etch

[Ron Johnson <ron.l.johnson@cox.net>]

On 11/03/08 02:54, 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.

Shouldn't mysqldump take care of this?

--
Ron Johnson, Jr.
Jefferson LA  USA

"I won't have to worry about putting gas in my car, I won't
have to worry about paying my mortgage."
Peggy Joseph, on why she loves Obama