Re: mysql Etch -> Etch

On 11/03/08 02:54, [EMAIL PROTECTED] 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

[SOLVED] Re: mysql Etch -> Etch

[EMAIL PROTECTED] wrote: Mariusz Sielicki wrote: Did you backup database named "mysql" too? This database contains users and grants data. Yes, I backuped all /var/lib/mysql/ But on start mysql: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'de

Re: mysql Etch -> Etch

Mariusz Sielicki wrote: Did you backup database named "mysql" too? This database contains users and grants data. Yes, I backuped all /var/lib/mysql/ But on start mysql: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost

Re: mysql Etch -> Etch

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 a

Re: mysql Etch -> Etch

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: mys

mysql Etch -> Etch

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 use