Project

General

Profile

Actions

Install

Basic Setup

Extended Setup

SELinux secured server

SSL secured web-server

configure outgoing mail

bug-fix

at least in our environment sending mails does not work out of the box. mail.php needs to be fixed. See also configure outgoing mail

Client Integration

owncloud_client_setup_thunderbird

improve performance

you may look up the performance thread in the owncloud-forum https://forum.owncloud.org/viewtopic.php?f=8&t=10692

setup cron.php-job

to check the logs of owncloud more easily you may want to make a symbolic link to the admin-files

ln -s /var/www/html/owncloud/data/owncloud.log /var/www/html/owncloud/data/admin/files/owncloud.log

h1. Migrate from SQLite3 to MySQL

Backup/Restore

a very interesting article is https://wiki.amahi.org/index.php/Backup_and_Recovery_of_ownCloud

Backup DB

SQLite

While SQLite-DB consists of just one file, you shouldn't just copy the file. It might be corrupted by doing so.

If you want to copy the DB-file you might want to (taken from http://stuvel.eu/blog/55/safely-copy-a-sqlite-database)

shell$ sqlite3 some.db
sqlite> begin immediate;
<press CTRL+Z>
shell$ cp some.db some.db.backup
shell$ exit
sqlite> rollback;

the other way may be dumping the DB. This is easily done by

sqlite3 sample.db .dump > sample.bak

based on the rsnapshot-backup-script for postgresql following script might be invoked by rsnapshot

##############################################################################
# backup_sqlite.sh
#
# by Jeremias Keihsler <j@keihsler.com>
# http://www.keihsler.com/
#
# based on the backup_pgsql.sh script
# by Nathan Rosenquist <nathan@rsnapshot.org>
# 
# This is a simple shell script to backup a SQLite database with rsnapshot.
#
# The assumption is that this will be invoked from rsnapshot and also that it
# will run unattended.
#
# This script simply needs to dump a file into the current working directory.
# rsnapshot handles everything else.
##############################################################################

umask 0077

# backup the database
/usr/bin/sqlite3 /var/www/html/owncloud/data/owncloud.db .dump > owncloud_dumpall.sql

# make the backup readable only by root
/bin/chmod 600 owncloud_dumpall.sql

Backup Files

as the "files" are not stored in the database but in the filesystem you also need to make a backup of those. Maybe the easiest way is to completely save the whole owncloud folder-structure via rsnapshot.

Following line may be added to rsnapshot.conf

backup         /var/www/html/owncloud           localhost/
backup_script  /usr/local/bin/backup_sqlite.sh  localhost/sqlite/

Restore DB

SQLite

mv sample.db sample.db.old
sqlite3 sample.db < sample.bak

mount web_dav

This requires davfs2-package

mount.davfs -o dir_mode=775 https://example.com/owncloud/remote.php/webdav /mnt/owncloud_dav/

Updated by Jeremias Keihsler almost 8 years ago · 4 revisions