I'm interested to hear feedback on this, since I was intending to backup a mySQL database 'on the fly' daily...
Anyone?
On 09/04/06, Veronica Hill <[EMAIL PROTECTED]> wrote:
Hi people!
I've been hunting around the web for an answer to this question for a
couple of days now. I run the IT for a small company and i don't have
a lot of experience with the type of C-ISAM database application that
is used by my company, I deal with the general IT issues and call in
specialists when required. But I need to backup this 10GB database to
a disaster recovery server on the other side of the continent. So my
first reaction was that if the database was shutdown then rsync would
be a great solution! But some opinions on the net muddy the issue.
Tridge's PHD thesis mentions that people use rsync for replicating
their databases to backup servers. i would have thought that that was
OK if the DBM was shutdown during the backup......
But some people on the net like this:
http://www.sanitarium.net/golug/rsync_backups.html
Say:
Why/When wouldn't you want to use rsync for backups?
Databases: Rsync is a file level backup so it is not suitable for
databases. If your primary data is databases then you should look
somewhere else. If you have databases but they are not your primary
data then there is a procedure below to integrate a database backup
into the rsync backups.
What pointers can people give me?
Thanks, Bye, Rony.
--
To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
-- To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
