I think that it is more than backing up the database you want to do. If I am right you want to synchronize the 2 databases in which case the answer is replication. Replication is described in the reference manual of MySQL.
Bernard On Tuesday 18 November 2003 04:59, Paco Martinez wrote: > 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]