[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysql Etch -> Etch

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

Reply to: