Version 2 (modified by 8 years ago) ( diff ) | ,
---|
UoL LAMP Backups
Tags: UoL LAMP Server SOP_Category
Server Backups
The LAMP servers are backed up hourly automatically as part of the LAMP service, although no separate database back up is taken.
To restore from a back up, contact the RCS Support.
Database Backups
All databases are backed up daily, weekly and monthly by running the /local/backupAllDatabases.sh
script from wwwrun
's crontab. The backups are stored in daily
, weekly
or monthly
sub-directory in the /local/backup
directory and zipped to save space. The most recent daily backup is also stored in the /local/backup/Latest
directory.
Backups are removed after a period of time, depending on their type:
- Daily
- 6 days
- Weekly
- 3 weeks
- Monthly
- 3 months
Restoring Databases
- If the database exists, remove the database by running the command
DROP DATABASE {database name}
from the mysql command prompt. - Unzip the backup file by running
gunzip {database name}-{backup date}.gz
- Recreate the database by running the command
mysql -u {username} -p {database name}{backup date}