From: Paco Martinez (pmartinezheraldo.es)
Date: Tue Nov 18 2003 - 04:36:32 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Just me has access to that machine...

And there's no LVM.

----- Original Message -----
From: "Simon Green" <sgreeneurobell.net>
To: <mysqllists.mysql.com>
Sent: Tuesday, November 18, 2003 11:12 AM
Subject: RE: Backup question.

> Has any one use LVM to take a snapshot in MySQL and use this to back up
> data?
>
> Simon
>
> -----Original Message-----
> From: Paco Martinez [mailto:pmartinezheraldo.es]
> Sent: 18 November 2003 10:00
> To: Christensen, Dave; 'Richard Reina'; mysqllists.mysql.com
> Subject: Re: Backup question.
>
>
> Is there any problem executing "rsync /var/lib/mysql/data/" from one host
to
> another host and therefore having same file in obth machines??
>
> Is it unsafe this method ??
>
> Could be crashed meanwhile transferring ??
>
> Thanks !!!
>
> ----- Original Message -----
> From: "Christensen, Dave" <DChristensentheimg.net>
> To: "'Richard Reina'" <Richardrushlogistics.com>; <mysqllists.mysql.com>
> Sent: Wednesday, November 12, 2003 10:20 PM
> Subject: RE: Backup question.
>
>
> > Yes, you can do it like this:
> >
> >
> > Prompt> mysqldump --add-drop-table --host=source.IP.addr.spec -uuser
> > -ppassword databasename | mysql -uuser -ppassword
> >
> >
> >
> > I've found that it helps things if you add --no-data to the source side
on
> > the first pass, then remove that clause and run it again.
> >
> > Dave
> >
> > -----Original Message-----
> > From: Richard Reina [mailto:Richardrushlogistics.com]
> > Sent: Wednesday, November 12, 2003 3:54 PM
> > To: mysqllists.mysql.com
> > Subject: Backup question.
> >
> >
> > I would like to backup databases from a linux MySQL server to another
> > linux machine on the same private network but I don' see in the docs how
> > I can do this with mysqlhotcopy or mysqldump. Is there any way to do
> > this besides using ftp.
> >
> > Any help would be appreicated.
> >
> > Richard
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=DChristensentheimg.net
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/mysql?unsub=pmartinezheraldo.es
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=sgreeneurobell.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=pmartinezheraldo.es

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]