Where is my database?

Server
1

Hello

I recently installed the ownclod 9 and it is running perfectly.
When I started to install it, with problems with the database, I installed and unzipped several times, with this
My database can be controlled, modified to database and used as a database.
How do I view the database you are using?

thank you

2

check your config.php file, there are information about your DB.

3

Hey,

it is not related to your question but if this is a new installation i think it doesn’t make any sense to install the end-of-life and unsupported version 9 of ownCloud.

Maybe you can re-do the setup with the current version 10.2.0 which seems to be provided at https://owncloud.org/download/#owncloud-server

1 Like
4

Thanks for the answer.

I checked inside config.php
and I found something like sqlite3, however upon entering sqlite3 and listing the tables returned empty, as if there were no tables.

—> /var/www/html/owncloud/config/config.php

<?php

$CONFIG = array (
‘instanceid’ => ‘000000000000’,
‘passwordsalt’ => ‘00000000000000000000000000’,
‘secret’ => ‘000000000000000000000000000000000000000000’,
‘trusted_domains’ =>
array (
0 => ‘192.168.10.108’,
1 => ‘mydomain.com.’,
2 => ‘0000000000000’,
3 => ‘192.168.10.131’
),
‘datadirectory’ => ‘/var/www/html/owncloud/data’,
‘overwrite.cli.url’ => ‘http://192.168.10.108’,
‘dbtype’ => ‘sqlite3’,
‘version’ => ‘10.0.7.2’,
‘logtimezone’ => ‘UTC’,
‘installed’ => true,
‘loglevel’ => 0,
);

----------------------->

sqlite> .databases
seq name file

0 main
sqlite>

5

Hey,

maybe having a look at the sqlite manual could help? But i think you need to give the full path to the sqlite database and use e.g. .tables to see the tables:

sqlite3 /var/www/html/owncloud/data/owncloud.db

This looks to me still quite outdated, i think its highly recommended to update to ownCloud 10.2.0.

1 Like
6

and try to use mysql or mariaDB.

1 Like
7

This is indeed a quite good additional hint for a fresh installation. From what i have read in the past the ownCloud team is considering to completely drop sqlite support.

To sum-up i would suggest to do a fresh setup with:

  1. MySQL/MariaDB
  2. Recent ownCloud 10.2.0 version
1 Like
8

Thank you for the informations,
I’m looking for the database, to just backup everything and restore on the new server.
Besides using the database, is there any tool that facilitates this bakcup and restoration process?

The database is in / var / www / html / owncloud / data /
-rw-r-r-. 1 apache apache 172494848 Jul 1 11:03 owncloud.db

How can I access this database?

ty

9

Hey,

i have opened the page https://doc.owncloud.org/server/10.2/admin_manual/ and put the word “backup” into the search box at the upper right corner and found the following documentation with a few seconds effort:

https://doc.owncloud.com/server/admin_manual/maintenance/backup.html

1 Like