Get a list of all files (sql query on MySQL)

Good afternoon!
In which database and table is the list of all files that users have? (
files, not directories)
Perhaps someone has already encountered a similar task.
There are SeaFiles not pro versions.
I must obtain information about which files have been updated by users?

You can find this in seafile-db, but I forgot the table.

Filenames are not hold in any database table and cannot be listed with an sql query. This is why the database does not grow much and why there performance is still very good with millions of files (and more).

You could mount all the libraries with the fuse extension and list them, if you really need to.

1 Like