wiki:UoL LAMP Backups

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

  1. If the database exists, remove the database by running the command DROP DATABASE {database name} from the mysql command prompt.
  2. Unzip the backup file by running gunzip {database name}-{backup date}.gz
  3. Recreate the database by running the command mysql -u {username} -p {database name}{backup date}

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Last modified 8 years ago Last modified on 08/01/16 14:00:07
Note: See TracWiki for help on using the wiki.