back up web server

[beeswax]

we're hoping to run the school's website from a dedicated server in (a dmz) in school. it will be built on a MySql database via a CMS. it will need to be backed up regularly. any suggestions?

[Geoff]

Linux or Windows?

[beeswax]

sorry, windows

A simple one would be to to make a copy of the site files via ftp and then export the SQL database to a file. Do this with my joomla sites and it works ok.

Then if the site dies / or you need to move to another host you just upload the files and repolulate the sql database.

[Geoff]

you can dump the mysql database to a file with the 'mysqldump' command.

[Ric_]

MySQL Administrator can also set up an automatic backup job for your database. This comes in a Windows flavour too

[CyberNerd]

How about using mysqlhotcopy to backup the database to the spare server and using rsync to synchronise the webpages, using a script that backs it up once per day.