Scheduled Database Backup - Revision history

Serdar Civici: /* Other Cloud Options */

2020-12-30T11:32:28Z

Other Cloud Options

Serdar Civici: /* Other Cloud Options */

2020-12-30T11:32:11Z

Other Cloud Options

Serdar Civici: /* Other Cloud Options */

2020-12-30T10:54:13Z

Other Cloud Options

Serdar Civici at 10:52, 30 December 2020

2020-12-30T10:52:32Z

Serdar Civici at 10:51, 30 December 2020

2020-12-30T10:51:53Z

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

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

2020-12-17T08:05:33Z

Sending Backup Folder to Google Drive

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

2020-12-17T08:01:41Z

Sending Backup Folder to Google Drive

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

2020-12-17T07:58:28Z

Sending Backup Folder to Google Drive

@@ Line 200: / Line 200: @@
 [[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]]

@@ Line 200: / Line 200: @@
 [[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]]

← Older revision		Revision as of 10: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]]

@@ Line 195: / Line 195: @@
 . 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]]

← Older revision		Revision as of 10: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]]

@@ Line 159: / Line 159: @@
 You can upload the backup folder to Google Drive.
-. Login to CLI via SSH and download the gdrive with the following command
+. 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
@@ Line 171: / Line 171: @@
     https://accounts.google.com/o/oauth2/auth?client_id=12345678901203-7n0vf5serdar7on...
-. 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
+. 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...
@@ Line 182: / Line 182: @@
 So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.
-. 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.
+. 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"
@@ Line 193: / Line 193: @@
-. 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.
+. 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.

@@ Line 182: / Line 182: @@
 So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.
-. 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.
+. 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" |
-# remove the compressed file
+. 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 ""
-−
-. 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.

@@ Line 159: / Line 159: @@
 You can upload the backup folder to Google Drive.
-* Login to CLI via SSH and download the gdrive with the following command
+. Login to CLI via SSH and download the gdrive with the following command
     sudo wget -O drive https://drive.google.com/uc?id=0B3X9GlR6EmbnMHBMVWtKaEZXdDg
-* Move GDrive to /usr/sbin/drive folder by entering this command:
+. Move GDrive to /usr/sbin/drive folder by entering this command:
    sudo mv drive /usr/sbin/drive
-* Set permissions:
+. Set permissions:
    sudo chmod 755 /usr/sbin/drive
-* run the drive command to start the authentication process. You will a link like the following;
+. run the drive command to start the authentication process. You will a link like the following;
     https://accounts.google.com/o/oauth2/auth?client_id=12345678901203-7n0vf5serdar7on...
-* 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
+. 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
   Enter verification code: 4/9gKYAFAJ326XIP6JJHAEhs342t35LPiA5QGW0935...
   You have installed Google Drive and Connected to your Google Drive account.
-* We need to create a bash script to upload files to Google Drive. Go to your Google Drive and create a folder. Go to the folder. Now, look at the URL. At the end of the URL, you can see the folder’s path. Look at the screenshot to be clear:
+. We need to create a bash script to upload files to Google Drive. Go to your Google Drive and create a folder. Go to the folder. Now, look at the URL. At the end of the URL, you can see the folder’s path. Look at the screenshot to be clear:
 [[Image:Google_Drive_1.png|800px]]
@@ Line 182: / Line 182: @@
 So, 0B02roDDQi5I8SUpLZ29RZ1A2YWc is the Mix folder’s path. Copy this path.
-* 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.
+. 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.
 # compress the directory
@@ Line 202: / Line 202: @@
 echo ""
-* 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.
+. 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 07:58, 17 December 2020
Line 161:		Line 161:
	* Login to CLI via SSH and download the gdrive with the following command		* Login 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
		+
		+	* Move GDrive to /usr/sbin/drive folder by entering this command:
		+	sudo mv drive /usr/sbin/drive
		+
		+	* Set permissions:
		+	sudo chmod 755 /usr/sbin/drive
		+
		+	* run the drive command to start the authentication process. You will a link like the following;
		+	https://accounts.google.com/o/oauth2/auth?client_id=12345678901203-7n0vf5serdar7on...
		+
		+	* 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:
		+	Enter verification code: 4/9gKYAFAJ326XIP6JJHAEhs342t35LPiA5QGW0935...
		+	You have installed Google Drive and Connected to your Google Drive account.