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}

