Scheduled Database Backup - Revision history

Luc Morissette: Remove the "Install" part as it is now installed by default on all systems

2024-06-13T18:40:00Z

Remove the "Install" part as it is now installed by default on all systems

@@ Line 5: / Line 5: @@
 = Overview =
 The ''tbdbbackup'' script supports the following features:
-*Backup the TMG-CONTROL configuration database into a backup file
+*Backup the configuration database into a backup file
 *Backup file name formatted as  ''tbdbbackup_<hostname>_toolpack_<version>_<date>_<time>.sql.gz''
    tbdbbackup_TB014369_toolpack_2_8_2017_01_11_15h52m.sql.gz
@@ Line 18: / Line 18: @@
   [root@TB014369 ~]# which tbdbbackup
   /usr/bin/tbdbbackup
 = Configuration =

Allyntree: minor edits

2023-02-23T14:51:37Z

minor edits

Show changes

Luc Morissette: Added title

2023-02-14T18:05:17Z

Added title

← Older revision		Revision as of 14:05, 14 February 2023
Line 1:		Line 1:
			{{DISPLAYTITLE:Scheduled Database Backup}}

	This procedure shows how to configure a periodic database backup using a bash script (''tbdbbackup'') executed from a Tmedia host unix cron jobs. Cron allows Linux and Unix users to run commands or scripts at a given date and time.<br><br>		This procedure shows how to configure a periodic database backup using a bash script (''tbdbbackup'') executed from a Tmedia host unix cron jobs. Cron allows Linux and Unix users to run commands or scripts at a given date and time.<br><br>

Serdar Civici: /* Other Cloud Options */

2020-12-30T11:32:28Z

Other Cloud Options

← Older revision		Revision as of 07:32, 30 December 2020
Line 200:		Line 200:
	[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]		[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]

	* You can upload your backups to '''Cloud Storage ~~bucket~~'''. Please check the following link below;		* You can upload your backups to '''Google Cloud Storage'''. Please check the following link below;

	[[FreeSBC:Uploading_backups_to_Google_Cloud_Bucket\|Uploading Backups to Google Cloud Bucket Instruction]]		[[FreeSBC:Uploading_backups_to_Google_Cloud_Bucket\|Uploading Backups to Google Cloud Bucket Instruction]]

Serdar Civici: /* Other Cloud Options */

2020-12-30T11:32:11Z

Other Cloud Options

← Older revision		Revision as of 07:32, 30 December 2020
Line 200:		Line 200:
	[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]		[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]

	* You can upload your backups to '''Cloud Storage bucket''. Please check the following link below;		* You can upload your backups to '''Cloud Storage bucket'''. Please check the following link below;

	[[FreeSBC:Uploading_backups_to_Google_Cloud_Bucket\|Uploading Backups to Google Cloud Bucket Instruction]]		[[FreeSBC:Uploading_backups_to_Google_Cloud_Bucket\|Uploading Backups to Google Cloud Bucket Instruction]]

Serdar Civici: /* Other Cloud Options */

2020-12-30T10:54:13Z

Other Cloud Options

← Older revision		Revision as of 06:54, 30 December 2020
Line 199:		Line 199:
	* You can upload your backups to '''AWS S3'''. Please check the link below;		* You can upload your backups to '''AWS S3'''. Please check the link below;
	[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]		[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]

			* You can upload your backups to '''Cloud Storage bucket''. Please check the following link below;

			[[FreeSBC:Uploading_backups_to_Google_Cloud_Bucket\|Uploading Backups to Google Cloud Bucket Instruction]]

Serdar Civici at 10:52, 30 December 2020

2020-12-30T10:52:32Z

← Older revision		Revision as of 06:52, 30 December 2020
Line 195:		Line 195:
	8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload the generated backup to google drive.		8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload the generated backup to google drive.

	==Other Cloud Options==		=Other Cloud Options=

	* You can upload your backups to AWS S3. Please check the link below;		* You can upload your backups to '''AWS S3'''. Please check the link below;
	[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]		[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]

Serdar Civici at 10:51, 30 December 2020

2020-12-30T10:51:53Z

← Older revision		Revision as of 06:51, 30 December 2020
Line 193:		Line 193:


	8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload the generated backup to google drive. ~~Cron job example~~ can ~~be found in this wiki~~.		8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload the generated backup to google drive.

			==Other Cloud Options==

			* You can upload your backups to AWS S3. Please check the link below;
	[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]		[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]

Serdar Civici at 08:47, 17 December 2020

2020-12-17T08:47:53Z

Serdar Civici: /* Sending Backup Folder to Google Drive */

2020-12-17T08:15:54Z

Sending Backup Folder to Google Drive

← Older revision		Revision as of 04:15, 17 December 2020
Line 182:		Line 182:
	So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.		So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.

	7. ~~Now create a~~ file ~~named “backup.sh” in~~ any folder of your server. The following file compress the /home/tbdbbackup folder and upload to ~~the~~ Google Drive. You can find other examples in the internet.		7. Download the following file and put any folder of your server. The following file compress the /home/tbdbbackup folder and upload to Google Drive. You can find other examples on the internet.

	~~# compress the directory~~		{\| cellpadding="5" border="1" class="wikitable"
	~~echo~~ "~~Compressing directory...~~"		\|-
	~~tar~~ -~~zcvf~~ "~~tbdbbackup~~-~~backup~~-~~$(date '+%d~~-%m-~~%Y').tgz~~" ~~/home/tbdbbackup~~		! width="200" style="background: rgb(239, 239, 239) none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;" \| Google Drive
	~~echo~~ "~~Directory compressed~~."		\|-
	~~echo ""~~		\| valign="top" \|
			*[[Media:google_drive.zip\|google_drive.sh]]
			\|}

	~~# upload to google drive~~
	~~echo "Uploading to Google Drive..."~~
	~~drive upload --file "tbdbbackup-backup-$(date '+%d-%m-%Y').tgz" -p 1F4j8gAM1OnJHsUJn0lamcQDiXci4GAUH~~
	~~echo "Uploaded to Google Drive."~~
	~~echo~~

	~~# remove the compressed file~~		8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload generated backup to google drive. Cron job example can be found in this wiki.
	~~echo "Clearing temporary files..."~~
	~~sudo rm "tbdbbackup-backup-$(date '+%d-%m-%Y').tgz"~~
	~~echo "Cleared temporary files."~~
	~~echo ""~~

	8. After ~~creating backup~~.sh file you need to add cron job to run after tbdbbackup and upload generated backup to google drive. Cron job example can be found in this wiki.

← Older revision		Revision as of 04:47, 17 December 2020
Line 159:		Line 159:
	You can upload the backup folder to Google Drive.		You can upload the backup folder to Google Drive.

	1. ~~Login~~ to CLI via SSH and download the gdrive with the following command		1. log in to CLI via SSH and download the gdrive with the following command
	sudo wget -O drive https://drive.google.com/uc?id=0B3X9GlR6EmbnMHBMVWtKaEZXdDg		sudo wget -O drive https://drive.google.com/uc?id=0B3X9GlR6EmbnMHBMVWtKaEZXdDg

Line 171:		Line 171:
	https://accounts.google.com/o/oauth2/auth?client_id=12345678901203-7n0vf5serdar7on...		https://accounts.google.com/o/oauth2/auth?client_id=12345678901203-7n0vf5serdar7on...

	5. Copy and paste the link in the browser. Accept the permission and you will get a verification code. Copy the verification and paste back into your shell		5. Copy and paste the link in the browser. Accept the permission and you will get a verification code. Copy the verification and paste it back into your shell

	Enter verification code: 4/9gKYAFAJ326XIP6JJHAEhs342t35LPiA5QGW0935...		Enter verification code: 4/9gKYAFAJ326XIP6JJHAEhs342t35LPiA5QGW0935...
Line 182:		Line 182:
	So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.		So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.

	7. Download the following file and put any folder of your server. The following file ~~compress~~ the /home/tbdbbackup folder and ~~upload~~ to Google Drive. You can find other examples on the internet.		7. Download the following file and put any folder on your server. The following file compresses the /home/tbdbbackup folder and uploads it to Google Drive. You can find other examples on the internet.

	{\| cellpadding="5" border="1" class="wikitable"		{\| cellpadding="5" border="1" class="wikitable"
Line 193:		Line 193:


	8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload generated backup to google drive. Cron job example can be found in this wiki.		8. After uploading the google_drive.sh file you need to add cron job to run after tbdbbackup and upload the generated backup to google drive. Cron job example can be found in this wiki.
			[[FreeSBC:Uploading_backups_to_AWS_S3\|Uploading Backupts to AWS S3 Instruction]]