Steps
- Setup ownCloud with sqlite
- Use
occ db:convert-type to convert to MySQL
- Refresh the page
Expected
All tables migrated
Actual
Some tables were omitted: oc_external_config, etc. These tables are created not with MDB2 schemas but with migrations.
Versions
master.
We need to adjust the command to also run the migrations on the new database to initially create the tables. I'm not sure if this will work correctly because a migration isn't always only creating tables...
± % occ db:convert-type --all-apps --password owncloud42 mysql owncloud localhost owncloudmb4
Creating schema in new database
The following tables will not be converted:
oc_external_applicable
oc_external_config
oc_external_mounts
oc_external_options
oc_migrations
Continue with the conversion (y/n)? [n] y
oc_activity
0 [>---------------------------]oc_activity_mq
0 [>---------------------------]oc_addressbookchanges
0 [>---------------------------]oc_addressbooks
1/1 [============================] 100%oc_appconfig
66/66 [============================] 100%oc_authtoken
1/1 [============================] 100%oc_calendarchanges
0 [>---------------------------]oc_calendarobjects
0 [>---------------------------]oc_calendars
1/1 [============================] 100%oc_calendarsubscriptions
0 [>---------------------------]oc_cards
0 [>---------------------------]oc_cards_properties
0 [>---------------------------]oc_comments
0 [>---------------------------]oc_comments_read_markers
0 [>---------------------------]oc_credentials
0 [>---------------------------]oc_dav_shares
0 [>---------------------------]oc_federated_reshares
0 [>---------------------------]oc_file_locks
3/3 [============================] 100%oc_filecache
14/14 [============================] 100%oc_files_trash
0 [>---------------------------]oc_group_admin
0 [>---------------------------]oc_group_user
1/1 [============================] 100%oc_groups
1/1 [============================] 100%oc_jobs
14/14 [============================] 100%oc_mimetypes
8/8 [============================] 100%oc_mounts
1/1 [============================] 100%oc_preferences
2/2 [============================] 100%oc_privatedata
0 [>---------------------------]oc_properties
0 [>---------------------------]oc_schedulingobjects
0 [>---------------------------]oc_share
0 [>---------------------------]oc_share_external
0 [>---------------------------]oc_storages
2/2 [============================] 100%oc_systemtag
0 [>---------------------------]oc_systemtag_group
0 [>---------------------------]oc_systemtag_object_mapping
0 [>---------------------------]oc_trusted_servers
0 [>---------------------------]oc_users
1/1 [============================] 100%oc_vcategory
0 [>---------------------------]oc_vcategory_to_object
0 [>---------------------------]
@DeepDiver1975
Steps
occ db:convert-typeto convert to MySQLExpected
All tables migrated
Actual
Some tables were omitted:
oc_external_config, etc. These tables are created not with MDB2 schemas but with migrations.Versions
master.
We need to adjust the command to also run the migrations on the new database to initially create the tables. I'm not sure if this will work correctly because a migration isn't always only creating tables...
@DeepDiver1975