Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Debian User (http://www.linux-archive.org/debian-user/)
-   -   mysql Etch -> Etch (http://www.linux-archive.org/debian-user/186738-mysql-etch-etch.html)

"webmaster@worldapart.com" 11-03-2008 07:54 AM

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

Ron Johnson 11-03-2008 08:21 AM

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


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

"Mariusz Sielicki" 11-03-2008 08:26 AM

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


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

"Kurian Thayil" 11-03-2008 08:27 AM

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:
mysql -u root <all-database_1.sql

Regards,

Kurian Mathew Thayil.

On 11/3/08, webmaster@worldapart.com <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.
>
> 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
>
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

"webmaster@worldapart.com" 11-03-2008 09:02 AM

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' (using
password: YES)'



Thanks.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

"webmaster@worldapart.com" 11-03-2008 09:14 AM

mysql Etch -> Etch
 
webmaster@worldapart.com 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 'debian-sys-maint'@'localhost' (using
password: YES)'



Thanks.


OK.

Now i check /etc/default/ and /etc/mysql/
Backuped and restored, and everything is OK now.

Thanks to all.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org


All times are GMT. The time now is 03:57 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.