Tom Hukins <[EMAIL PROTECTED]> writes: > That's fine if you're working with a typical filesystem, but what if > you're working with database tables? I'd normally dump the tables to > a file and backup the dump. However, I guess you'd end up rsyncing > the whole database if you did this. I guess you could archive > transaction logs, but for a frequently changing database the logs will > get quite large.
Like you say, dump the tables to a file. Then use rsync on the dump file. Of course, one must also remember to /not/ rsync the actual database. :) -Dom -- | Semantico: creators of major online resources | | URL: http://www.semantico.com/ | | Tel: +44 (1273) 722222 | | Address: 33 Bond St., Brighton, Sussex, BN1 1RD, UK. |
