Um den Datenbanktyp wechseln zu können sind die Softwareprodukte php, apache und mysql mit diversen Zusatzpaketen erforderlich.
Zur Installation bitte den folgenden Artikel beachten:
UBUNTU Installation apache php5 und mysql
Änderung des Datenbanktyps von sqlite zu mysql:
Es muss eine leere Datenbank in mysql angelegt werden.
root@lemaker:/var/www/html/owncloud# mysql -u root mysql -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 505 Server version: 5.5.41-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database owncloud; Query OK, 1 row affected (0.00 sec) mysql> exit; Bye root@lemaker:/var/www/html/owncloud#
Dann den folgenden Befehl im Stammverzeichnis von ownloud eingeben:
# Format des Aufrufs: php occ db:convert-type <Datenbanktyp> <DB-Username> <DB-Hostname> <Datenbankname>
# Weicht die Datenbankinstallation vom Standard ab kann alternativ ein Socket, oder IP:Port angegeben werden.
root@lemaker:/var/www/html/owncloud# php occ db:convert-type mysql root localhost owncloud
What is the database password?
Creating schema in new database
The following tables will not be converted:
oc_media_albums
oc_media_artists
oc_media_sessions
oc_media_songs
oc_media_users
oc_permissions
oc_queuedtasks
Please note that tables belonging to available but currently not installed apps
can be included by specifying the --all-apps option.
Continue with the conversion?y
oc_appconfig
90/90 [============================] 100%
oc_clndr_calendars
2/2 [============================] 100%
oc_clndr_objects
255/259 [===========================>] 98%
oc_clndr_repeat
12/12 [============================] 100%
oc_clndr_share_calendar
0/0 [============================] 0%
oc_clndr_share_event
0/0 [============================] 0%
oc_contacts_addressbooks
2/2 [============================] 100%
oc_contacts_cards
335/338 [===========================>] 99%
oc_contacts_cards_properties
2120/2124 [===========================>] 99%
oc_file_map
0/0 [============================] 0%
oc_filecache
170/172 [===========================>] 98%
oc_files_trash
3/3 [============================] 100%
oc_gallery_sharing
0/0 [============================] 0%
oc_group_admin
0/0 [============================] 0%
oc_group_user
2/2 [============================] 100%
oc_groups
2/2 [============================] 100%
oc_jobs
1/1 [============================] 100%
oc_locks
0/0 [============================] 0%
oc_lucene_status
66/66 [============================] 100%
oc_mimetypes
14/14 [============================] 100%
oc_pictures_images_cache
0/0 [============================] 0%
oc_preferences
15/15 [============================] 100%
oc_privatedata
0/0 [============================] 0%
oc_properties
0/0 [============================] 0%
oc_share
0/0 [============================] 0%
oc_share_external
0/0 [============================] 0%
oc_storages
6/6 [============================] 100%
oc_users
2/2 [============================] 100%
oc_vcategory
40/40 [============================] 100%
oc_vcategory_to_object
78/78 [============================] 100%
root@lemaker:/var/www/html/owncloud#