Backup and Recovery of ownCloud - Revision history

Bigfoot65: /* ownCloud Update and Upgrade */

2020-06-23T03:08:45Z

ownCloud Update and Upgrade

Bigfoot65: /* Upgrade */

2020-06-23T03:08:25Z

Upgrade

Bigfoot65: /* Restore ownCloud Files */

2020-06-23T03:08:10Z

Restore ownCloud Files

Bigfoot65: /* ownCloud Update and Upgrade */

2020-06-23T03:07:55Z

ownCloud Update and Upgrade

Bigfoot65 at 03:06, 23 June 2020

2020-06-23T03:06:38Z

Show changes

Bigfoot65: /* Configure */

2020-06-23T02:44:25Z

Configure

Ken Neiser (aka northridgegrp): /* Restore ownCloud */

2016-11-14T14:58:00Z

Restore ownCloud

Ken Neiser (aka northridgegrp): /* Configure */

2015-09-22T20:07:36Z

Configure

Ken Neiser (aka northridgegrp): /* Restore ownCloud */

2015-09-16T21:07:51Z

Restore ownCloud

Ken Neiser (aka northridgegrp): /* rsnapshot Backup Directories */

2015-09-11T19:38:47Z

rsnapshot Backup Directories

@@ Line 230: / Line 230: @@
 * Restore the ownCloud "config.php" file from the most recent backups with the following:
   rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/web-apps/owncloud/html/config/config.php /var/hda/web-apps/owncloud/html/config/
 * Restore the ownCloud "apps" directory from the most recent backups with the following:
@@ Line 237: / Line 236: @@
 * The following command-line entry will restore the ownCloud database from the most recent backups:
   mysql -u owncloud -powncloud owncloud < /var/hda/backups/daily.0/owncloud/database_dump/owncloud_db.sql
 :'''NOTE:''' For all releases on or after ownCloud 6, change all instances of ''owncloud'' to ''owncloud6''.
 ===== Upgrade =====

@@ Line 248: / Line 248: @@
 * The following command-line entry will restore the ownCloud database from the most recent backups:
   mysql -u owncloud -powncloud owncloud < /var/hda/backups/daily.0/owncloud/database_dump/owncloud_db.sql
 :'''NOTE:''' For all releases on or after ownCloud 6, change all instances of ''owncloud'' to ''owncloud<major release number> (i.e. owncloud6)''.

← Older revision		Revision as of 03:08, 23 June 2020
Line 214:		Line 214:
	* Enter the following "rsync" command to restore the "files" directory from the most recent backups. Depending on the amount of data stored the restore could take sometime.		* Enter the following "rsync" command to restore the "files" directory from the most recent backups. Depending on the amount of data stored the restore could take sometime.
	rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/files /var/hda/		rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/files /var/hda/
−

@@ Line 226: / Line 226: @@
 image	=oc_tip.png|
 heading	=ownCloud Tip!|
-message = Before going further please become acquainted with the ''[[Upgrading ownCloud to New Version Releases|Upgrading ownCloud to New Version Releases]]'' Wiki article. <!--ownCloud Tip ends-->
+message = Before going further please become acquainted with the ''[[Upgrading ownCloud to New Version Releases|Upgrading ownCloud to New Version Releases]]'' Wiki article.}} <!--ownCloud Tip ends-->
 ===== Update =====

@@ Line 56: / Line 56: @@
 * Create the "backups" directory and set permissions/ownership.
-<blockquote>{{Code|cd /var/hda
+ cd /var/hda
-mkdir backups
+ mkdir backups
-chmod 755 backups
+ chmod 755 backups
-chown root:root backups}}
+ chown root:root backups
 * Move to the "/etc" directory.
-<blockquote>{{Code|cd /etc}}
+ cd /etc
 * Make a backup copy of the rsnapshot configuration file. Why? So that there is a reference just in case.
-<blockquote>{{Code|cp rsnapshot.conf rsnapshot.conf.bkup}}
+ cp rsnapshot.conf rsnapshot.conf.bkup
 * Now using a favourite editor, open the "rnapshot.conf" file.
@@ Line 78: / Line 74: @@
 * Find the "SNAPSHOT ROOT DIRECTORY" section and change "snapshot_root" to path where the backups will be stored.
-<blockquote>
+ snapshot_root	/var/hda/backups/
 * Find the "BACKUP INTERVALS" section and change the line items. What does this all mean? The "#" character at the beginning of each line means the configuration line item will not be enabled. The "#" is know to set a line to be a "comment" line. The "interval daily" line will be active and 7 days of backups will be kept.
-<blockquote>
+ #interval	hourly	6
-{{Text|Text=
+ interval	daily	7
   #interval	weekly	4
   #interval	monthly	1
 * Find the "logfile" line and change the line item. The rsnapshot log file will be kept under the "backups" directory.
-<blockquote>
+ logfile	/var/hda/backups/logs/rsnapshot
 * Find the "BACKUP POINTS / SCRIPTS" section. Add changes as seen below. This is the section that defines the "key directories" source that will be backed up. See the "owncloud/" at the end of each line? Remember the previous "green" server folder? This is where the ownCloud binaries and physical files will be stored.
-<blockquote>
+ backup	/var/hda/files/owncloud owncloud/
-{{Text|Text=backup	/var/hda/files/		owncloud/
+ backup	/var/hda/web-apps/owncloud/ owncloud/
 * Next find the line "Backup OwnCloud MySQL database" change as shown below. This set the location where the ownCloud "database dump" backup will be kept. Also the line shows the execution path for the database backup program script file that performs the database backup.
-<blockquote>
+ backup_script	/usr/local/bin/backup_mysql.sh	owncloud/database_dump
 * Save the "rsnapshot.conf" file and return to the command-line prompt.
@@ Line 122: / Line 101: @@
 * Copy database backup script to the "/usr/local/bin/".
-<blockquote>{{Code|cp /usr/share/doc/rsnapshot*/utils/backup_mysql.sh }}
+ cp /usr/share/doc/rsnapshot*/utils/backup_mysql.sh
 :'''*''' - indicates rsnapshot version number
@@ Line 129: / Line 107: @@
 * Go to the "/usr/local/bin/" directory and set the script file permissions and ownership.
-<blockquote>{{Code|cd /usr/local/bin/
+ cd /usr/local/bin/
-chown root:root /usr/local/bin/backup_mysql.sh
+ chown root:root /usr/local/bin/backup_mysql.sh
-chmod 754 /usr/local/bin/backup_mysql.sh
+ chmod 754 /usr/local/bin/backup_mysql.sh
 * Edit the "backup_mysql.sh" file.
@@ Line 139: / Line 115: @@
 * Find the line "backup the database" and add the line has shown below. This will be the command that will be issued to do the database backup. The database dump file will be called "owncloud_db.sql".
-<blockquote>
+ /usr/bin/mysqldump -uowncloud -powncloud owncloud  > owncloud_db.sql
 * Find the line "# make the backup readable only by root" and add the line shown below.
-<blockquote>
+ /bin/chmod 600 owncloud_db.sql
 * Save the "backup_mysql.sh" file and return to the command-line prompt.

@@ Line 224: / Line 224: @@
 * Restore the ownCloud "apps" directory from the most recent backups with the following:
 <blockquote>{{Code|rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/web-apps/owncloud/html/apps /var/hda/web-apps/owncloud/html/}}
 </blockquote>
 * Restore the ownCloud database from the most recent backups using the database dump file:
 <blockquote>{{Code|mysql -u owncloud -powncloud owncloud < /var/hda/backups/daily.0/owncloud/database_dump/owncloud_db.sql}}
 </blockquote>

@@ Line 221: / Line 221: @@
 * Go to a "terminal" session and login to the "root" user ID.
-* Restore the ownCloud "config" directory from the most recent backups with the following:
+* Restore the ownCloud "config.php" file from the most recent backups with the following:
-<blockquote>{{Code|rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/web-apps/owncloud/html/config /var/hda/web-apps/owncloud/html/}}
+<blockquote>{{Code|rsync -avr --delete /var/hda/backups/daily.0/owncloud/var/hda/web-apps/owncloud/html/config/config.php /var/hda/web-apps/owncloud/html/config/}}
 </blockquote>

@@ Line 39: / Line 39: @@
 |- valign="top"
 | border="0" | [[File:Oc_backup_files_1c_v3.png |left]]
-| border="0" | The "backups" directory (red folder) shown here is located in the same filesystem location as the Amahi hda structures. This is '''''not a recommended practice''''' as the backups directory could be on the same hard disk(s) as the hda directories, it is only intended as an example for this article only. Normally the backups directory structure should be stored in a separate hard disk assembly (i.e. external drive) from the source hda structures.
+| border="0" | The "backups" directory (red folder) shown here is located in the same filesystem location as the Amahi hda structures. This is '''''not a recommended practice''''' as the backups directory could be on the same hard disk(s) as the hda directories, it is '''only intended as an example''' for this article only. Normally the backups directory structure should be stored in a separate hard disk assembly (i.e. external drive) from the source hda structures.
 <br/>
 The "daily.0" is created by the rsnapshot application to store "snapshot-like" backups. This particular directory name is typical of the doing a "daily" backup with rsnapshot. The directories "daily.x" and "daily.y" are just pseudo names where each value of x and y are normally numbers indicating later version numbers of rnsapshot backup sets. If rsnapshot daily backups are set for a 7 day retention the numbering would be 0 to 6, where daily.0 is the most recent backup set and 6 the latest set.