SLUG Mailing List Archives
Re: [SLUG] MySQL server to server data transfer
- To: slug@xxxxxxxxxxx
- Subject: Re: [SLUG] MySQL server to server data transfer
- From: "Voytek" <lists@xxxxxxxxxx>
- Date: Sat, 21 May 2005 20:51:36 +1000 (EST)
- User-agent: SquirrelMail/1.5.0
<quote who="Dean Hamstead">
> you could use replication temporarily
> just set it up, then run
> LOAD DATA FROM MASTER
> boom, off it goes.
would you know: would replication be suitable for an offsite backup, as
in, say, 'once a day' sync ?
most of the MySQL data is 'web content' and, is largely static
at this time, I dump all the data once every 24 hrs, then, copy it over.