Migrate nextcloud sqlite database to mysql inside docker

up vote
0
down vote

favorite

migrate sqlite to mariadb inside a docker image?

I installed the docker-compose example from the nextcloud readme (the base version with apache) but that one still uses sqlite, although there is created a db docker image as well, but it is not used.

How do I migrate the sqlite to the created db-docker image?

I tried:

docker-compose exec --user www-data app php occ db:convert-type --all-apps mysql nextcloud 127.0.0.1 nextcloud

which asks for the database password then, but the password I initially set in docker-compose.yml doesn't work

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

add a commentÂ |Â

up vote
0
down vote

favorite

migrate sqlite to mariadb inside a docker image?

How do I migrate the sqlite to the created db-docker image?

I tried:

docker-compose exec --user www-data app php occ db:convert-type --all-apps mysql nextcloud 127.0.0.1 nextcloud

which asks for the database password then, but the password I initially set in docker-compose.yml doesn't work

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

add a commentÂ |Â

up vote
0
down vote

favorite

migrate sqlite to mariadb inside a docker image?

How do I migrate the sqlite to the created db-docker image?

I tried:

docker-compose exec --user www-data app php occ db:convert-type --all-apps mysql nextcloud 127.0.0.1 nextcloud

which asks for the database password then, but the password I initially set in docker-compose.yml doesn't work

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

migrate sqlite to mariadb inside a docker image?

How do I migrate the sqlite to the created db-docker image?

I tried:

docker-compose exec --user www-data app php occ db:convert-type --all-apps mysql nextcloud 127.0.0.1 nextcloud

which asks for the database password then, but the password I initially set in docker-compose.yml doesn't work

docker nextcloud

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

edited Aug 13 at 8:50

asked Aug 13 at 8:37

rubo77

7,0052365125

asked Aug 13 at 8:37

rubo77

7,0052365125

asked Aug 13 at 8:37

rubo77

7,0052365125

add a commentÂ |Â

1 Answer
1

active

oldest

votes

up vote
0
down vote

This is not an answer how to migrate but I found out:

how to install nextcloud with mysql in docker

If you have a broken installation, delete it with

docker-compose down

this deletes the containers but keeping the data in volumes.
If you really want to start over, delete the volumes also.

Restart the docker installation with

docker-compose up -d

now you will have this screen on your web access:

enter image description here

There is a small link Storage & Database the middle. click on it and you can select mysql as database backend this time ;)

enter image description here

For the database use db as host and nextcloud as table and user name and enter the MYSQL_PASSWORD from your docker-compose.yml.

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f462245%2fmigrate-nextcloud-sqlite-database-to-mysql-inside-docker%23new-answer', 'question_page');

);

Post as a guest

Name

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

This is not an answer how to migrate but I found out:

how to install nextcloud with mysql in docker

If you have a broken installation, delete it with

docker-compose down

this deletes the containers but keeping the data in volumes.
If you really want to start over, delete the volumes also.

Restart the docker installation with

docker-compose up -d

now you will have this screen on your web access:

enter image description here

There is a small link Storage & Database the middle. click on it and you can select mysql as database backend this time ;)

enter image description here

For the database use db as host and nextcloud as table and user name and enter the MYSQL_PASSWORD from your docker-compose.yml.

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

add a commentÂ |Â

up vote
0
down vote

This is not an answer how to migrate but I found out:

how to install nextcloud with mysql in docker

If you have a broken installation, delete it with

docker-compose down

this deletes the containers but keeping the data in volumes.
If you really want to start over, delete the volumes also.

Restart the docker installation with

docker-compose up -d

now you will have this screen on your web access:

enter image description here

There is a small link Storage & Database the middle. click on it and you can select mysql as database backend this time ;)

enter image description here

For the database use db as host and nextcloud as table and user name and enter the MYSQL_PASSWORD from your docker-compose.yml.

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

add a commentÂ |Â

up vote
0
down vote

This is not an answer how to migrate but I found out:

how to install nextcloud with mysql in docker

If you have a broken installation, delete it with

docker-compose down

this deletes the containers but keeping the data in volumes.
If you really want to start over, delete the volumes also.

Restart the docker installation with

docker-compose up -d

now you will have this screen on your web access:

enter image description here

There is a small link Storage & Database the middle. click on it and you can select mysql as database backend this time ;)

enter image description here

For the database use db as host and nextcloud as table and user name and enter the MYSQL_PASSWORD from your docker-compose.yml.

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

This is not an answer how to migrate but I found out:

how to install nextcloud with mysql in docker

If you have a broken installation, delete it with

docker-compose down

this deletes the containers but keeping the data in volumes.
If you really want to start over, delete the volumes also.

Restart the docker installation with

docker-compose up -d

now you will have this screen on your web access:

enter image description here

There is a small link Storage & Database the middle. click on it and you can select mysql as database backend this time ;)

enter image description here

For the database use db as host and nextcloud as table and user name and enter the MYSQL_PASSWORD from your docker-compose.yml.

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

edited Aug 13 at 13:12

answered Aug 13 at 13:00

rubo77

7,0052365125

answered Aug 13 at 13:00

rubo77

7,0052365125

answered Aug 13 at 13:00

rubo77

7,0052365125

add a commentÂ |Â

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

搜尋此網誌

mjhjmtu