From: Bernard Clement (bernardinfo-electronics.com)
Date: Tue Nov 18 2003 - 04:40:30 CST

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

rsynch will do the job correctly only and only if the mysql server on both
sides are not running. Rsynch does not deal with files opened for writing
and my guess is that MySQL is opening the database (i.e. files) for writing.

As for LVM (AKA Logical Volume Manager) I really do not see how it could be
used to take a snapshot in MySQL. However, I could be wrong here.

Bernard

On Tuesday 18 November 2003 05:12, Simon Green wrote:
> 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

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