Just me has access to that machine... And there's no LVM.
----- Original Message ----- From: "Simon Green" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: 18 November 2003 10:00 > To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: "'Richard Reina'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > > Sent: Wednesday, November 12, 2003 3:54 PM > > To: [EMAIL PROTECTED] > > 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/[EMAIL PROTECTED] > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]