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 [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > 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]
