Backup Linux to Windows (Was: Re: wiki on windows)

[Alex Dean]

> hacktavist at cox.net wrote:
>> I had a question regarding this. I work in an (almost) complete windows 
>> shop, one linux box which is mine. :-) can i get windows too push data 
>> from a linux box over to a windows server to be available for a back up.

Keep in mind that if you use a wiki which uses a database backend, a 
filesystem-level backup won't necessarily guarantee that the data files 
are in a consistent state.  (Though that depends on the backup software 
and DBMS in question.)

You'll probably need to stop the database before the backup starts, or 
lock all tables while the backup is running.  Check into the tools 
available for your database.

For a small system, writing a cron job to dump the data to a SQL file 
should be fine.  The system backups can then pick up the SQL file. 
MySQL's mysqldump utility works great for this.

alex