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]
