beeswax Posted June 12, 2006 Posted June 12, 2006 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?
Guest Posted June 12, 2006 Posted June 12, 2006 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 Posted June 12, 2006 Posted June 12, 2006 you can dump the mysql database to a file with the 'mysqldump' command.
Ric_ Posted June 12, 2006 Posted June 12, 2006 MySQL Administrator can also set up an automatic backup job for your database. This comes in a Windows flavour too
CyberNerd Posted June 12, 2006 Posted June 12, 2006 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now