Shells backup: Difference between revisions

Latest revision as of 08:04, 25 July 2025

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 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

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

This will open up your crontab for editing. Add the following command to make a daily backup of your database.

@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. Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).

Not that there is no space between -p and your password.

@@ Line 1: / Line 1: @@
-We make full backups of all the home directories to an off-site server every Monday, Wednesday and Friday at 5:40am local time.
+=== 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 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.)
-To restore a file from this backup to your account you can use the '''backup''' command.
+=== MySQL database backups ===
-You can also use the same command to back up a file at any time.
-Usage:
+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.
-: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)
+ user@Lydia:~$ crontab -e
-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].
+This will open up your crontab for editing. Add the following command to make a daily backup of your database.
+ @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.
-Known bugs:
+Make sure to include the full path in the backup file name. (/home/username/mybackup/database.sql).
-: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.
+:Not that there is '''no space''' between -p and your password.

Shells backup: Difference between revisions

Latest revision as of 08:04, 25 July 2025

File backups

MySQL database backups

Navigation menu

Search