How to remove the SQLITE database?

ℹ️ Support
1

I configured a new MySQL database in the config.php but my instance is instead using a previously configured SQLITE instance that was automatically setup during the initial installation.

How can I force Nextcloud to stop using the SQLITE database and use the one configured in the config/config.php file?

2

hi @shellwhale welcome to the forum :handshake:

Please use the search - lot of issues have been discussed already

official docs for the task you are looking for is here: Converting database type — Nextcloud latest Administration Manual latest documentation

3

Basically I’m trying to perform a migration, the data is all there but the config file does not seem to be parsed by Nextcloud.

So I think there must be a file that was modified/created somewhere when I’ve wrongfully setup the second instance but I don’t know which one.

4

Hello,

Thank your for your answer.

However, I am not trying to make conversion, just use a another already existing database.

I am trying to make a migration. I dumped the whole database and imported it to another DB cluster. I copied the whole /var/www/nextcloud folder and and copied it to a new server.

When I started the webserver I got the initial installation page, not the login page with my theme, my users etc. I’ve clicked the button to complete the setup not knowing it would create an SQLITE database.

It has also overwritten the config/config.php that I copied from the initial server.

So I tried copying back the config.php file and now the new Nextcloud instance does not take my database config into account.

5

You can use this command for your Nextcloud:

https://cloud.server.tld/ocs/v2.php/apps/serverinfo/api/v1/info

There you can find infos from your database. Please check your config.php again. If you set up your webserver correctly it is /var/www/nextcloud/config/config.php.

6

Sounds like maybe a migration step was missed somewhere along the way. Were you using the officially documented migration approach or some other process?

The easiest/ safest thing to do would probably be to reverse course and regroup then try the process again.

7

I managed to find an explanation and a solution to my issue. The path to the data folder in the config.php was incorrect. The new server used /var/www/html instead of /var/www/nextcloud

8

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.