From: Paco Martinez (pmartinezheraldo.es)
Date: Tue Nov 18 2003 - 03:59:57 CST

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

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

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