Changes between Initial Version and Version 1 of UoL LAMP Backups

Timestamp:

07/21/16 09:30:21 (8 years ago)

Author:

Richard Bramley

Comment:

--

UoL LAMP Backups

@@ +1 @@
+= UoL LAMP Backups
+
+Tags: [[UoL LAMP Server]]
+
+== 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.
+1. Unzip the backup file by running `gunzip {database name}-{backup date}.gz`
+1. Recreate the database by running the command `mysql -u {username} -p {database name}{backup date}`
+
+[[BackLinks]]