Shells backup - Revision history

Admin at 08:04, 25 July 2025

2025-07-25T08:04:55Z

← Older revision		Revision as of 08:04, 25 July 2025
Line 5:		Line 5:
	=== MySQL database backups ===		=== MySQL database backups ===

	We do include a ~~backup~~ of ~~the full MySQL server~~ in our backups~~, but it is usually not practical to try and restore a single database from the master backup~~. ~~Therefore if~~ you ~~require backups of~~ your ~~MySQL~~ database~~(s)~~ we recommend you create a cronjob to dump your database on a regular basis.		We already include a dump of every database in our backups. If you want to have autonomous control over your database backups we recommend you create a cronjob to dump your database on a regular basis.

	user@Lydia:~$ crontab -e		user@Lydia:~$ crontab -e
Line 15:		Line 15:
	Obviously you need to replace the username, password, database and backupfile.sql with the ones you use.		Obviously you need to replace the username, password, database and backupfile.sql with the ones you use.
	Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).		Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).
	:~~There~~ is '''no space''' between -p and your password!		:Not that there is '''no space''' between -p and your password.

Admin: /* File backups */

2020-02-14T00:29:41Z

File backups

← Older revision		Revision as of 00:29, 14 February 2020
Line 1:		Line 1:
	=== File backups ===		=== File backups ===

	A nightly backup of the main storage (SSD array) is made every day at 11pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These ~~copies~~ are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)		A nightly backup of the main storage (SSD array) is made every day at 11pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These backups are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)

	=== MySQL database backups ===		=== MySQL database backups ===

Admin: /* File backups */

2020-02-14T00:29:16Z

File backups

← Older revision		Revision as of 00:29, 14 February 2020
Line 1:		Line 1:
	=== File backups ===		=== File backups ===

	A nightly ~~copy~~ of the main storage (SSD array) is made every day at 11pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These copies are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)		A nightly backup of the main storage (SSD array) is made every day at 11pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These copies are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)

	=== MySQL database backups ===		=== MySQL database backups ===

imported>Wikiadmin: /* File backups */

2019-02-25T22:13:47Z

File backups

← Older revision		Revision as of 22:13, 25 February 2019
Line 1:		Line 1:
	=== File backups ===		=== File backups ===

	A nightly copy of the main storage (SSD array) is made every day at ~~10pm~~ local time. For the coldstorage drive there is a weekly backup made every Sunday. These copies are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)		A nightly copy of the main storage (SSD array) is made every day at 11pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These copies are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)


	=== MySQL database backups ===		=== MySQL database backups ===

imported>Wikiadmin: Rewrite backups page to be inline with current policies

2019-02-25T10:59:02Z

Rewrite backups page to be inline with current policies

← Older revision		Revision as of 10:59, 25 February 2019
Line 1:		Line 1:
	~~We make full backups of all the home directories and databases to an off-site server every Monday, Wednesday and Friday at 5:40am local time.~~


	=== File backups ===		=== File backups ===

	~~To restore a file from this backup to your account you can use~~ the ~~'''backup''' command~~.		A nightly copy of the main storage (SSD array) is made every day at 10pm local time. For the coldstorage drive there is a weekly backup made every Sunday. These copies are mainly meant to have a restore point in case some form of catastrophic failure should occur, however if you need files from the backup you can contact a member of our staff to help restore it for you. (In the future we will be adding an automated system for this, but for now contacting staff is the only way.)
	~~You can also use~~ the ~~same command to back up~~ a ~~file at any time.~~

	~~Usage:~~
	:backup ~~-r /home/username/file.txt restores file~~.~~txt~~ to ~~the version found~~ in the backup~~. (option -r is the same as --~~restore)
	~~:backup -b /home/username/file.txt saves file.txt to the backup server~~. (~~option -b is~~ the ~~same as --backup)~~


	~~If you want to check the last date and time a backup was made~~, ~~you can check at [http://backup.insomnia247.nl~~ the ~~backup webinterface]~~.


	~~Known bugs:~~
	:Filenames with spaces aren't handled properly yet. They are backed up in the periodical backups, but they can't be restored automatically. If you need such a file restored please ask one of our staff members to restore it manually.

	~~:When working with restoring a directory make sure to include a trailing / to ensure the restored folder is created properly.~~
	~~backup -r /home/user/directoryname/~~

	=== MySQL database backups ===		=== MySQL database backups ===

	~~Though we~~ do include the MySQL ~~databases~~ in our backups, ~~you can~~ not restore ~~them manually (due to file permissions etc~~.)		We do include a backup of the full MySQL server in our backups, but it is usually not practical to try and restore a single database from the master backup. Therefore if you require backups of your MySQL database(s) we recommend you create a cronjob to dump your database on a regular basis.
	~~Should you need this feature, or do~~ you ~~want to keep extra~~ backups of your ~~databases for whichever other reason,~~ you ~~can~~ create a cronjob to ~~do so~~.

	user@Lydia:~$ crontab -e		user@Lydia:~$ crontab -e
Line 30:		Line 12:
	This will open up your crontab for editing. Add the following command to make a daily backup of your database.		This will open up your crontab for editing. Add the following command to make a daily backup of your database.

	@daily mysqldump -u ~~username~~ -~~pmysqlpassword databasename~~ > ~~backupfile~~.sql		@daily mysqldump -u databse_username -pdatabase_password database_name > $HOME/mysql_backups/my_database.sql

	Obviously you need to replace the username, password, database and backupfile.sql with the ones you use.		Obviously you need to replace the username, password, database and backupfile.sql with the ones you use.
	Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).		Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).
	:There is '''no space''' between -p and your password!		:There is '''no space''' between -p and your password!


	~~You can also add the backup command trough your [https://www.insomnia247.nl:20000 usermin] under Others -> Scheduled Cron Jobs -> Create a new scheduled cron job.~~

	~~You do not need to add the @daily to the command if you do it through usermin. The timing of when the backups are made can be specified on the Cron Job creation page.~~

imported>Wikiadmin at 12:18, 21 December 2014

2014-12-21T12:18:05Z

← Older revision	Revision as of 12:18, 21 December 2014
(No difference)

imported>Wikiadmin at 12:18, 21 December 2014

2014-12-21T12:18:05Z

← Older revision		Revision as of 12:18, 21 December 2014
Line 18:		Line 18:
	:Filenames with spaces aren't handled properly yet. They are backed up in the periodical backups, but they can't be restored automatically. If you need such a file restored please ask one of our staff members to restore it manually.		:Filenames with spaces aren't handled properly yet. They are backed up in the periodical backups, but they can't be restored automatically. If you need such a file restored please ask one of our staff members to restore it manually.

			:When working with restoring a directory make sure to include a trailing / to ensure the restored folder is created properly.
			backup -r /home/user/directoryname/

	=== MySQL database backups ===		=== MySQL database backups ===

imported>Wikiadmin at 14:01, 15 July 2011

2011-07-15T14:01:35Z

← Older revision	Revision as of 14:01, 15 July 2011
(No difference)

imported>Wikiadmin at 14:01, 15 July 2011

2011-07-15T14:01:35Z

← Older revision		Revision as of 14:01, 15 July 2011
Line 20:		Line 20:

	=== MySQL database backups ===		=== MySQL database backups ===

	Though we do include the MySQL databases in our backups, you can not restore them manually (due to file permissions etc.)		Though we do include the MySQL databases in our backups, you can not restore them manually (due to file permissions etc.)
	Should you need this feature, or do you want to keep extra backups of your databases for whichever other reason, you can create a cronjob to do so.		Should you need this feature, or do you want to keep extra backups of your databases for whichever other reason, you can create a cronjob to do so.

imported>Wikiadmin at 13:57, 15 July 2011

2011-07-15T13:57:34Z

← Older revision	Revision as of 13:57, 15 July 2011
(No difference)