wiki:UoL LAMP Backups

Version 2 (modified by Richard Bramley, 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

  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'

Note: See TracWiki for help on using the wiki.