Detect / Delete App Data

[tflidd]

Use case:

• You tested an app and decided not to use it
• The app is not available any more for current NC versions

What I want:

• Delete all app-related data from user folders and database, e.g. an additional button on the web-interface where you enable and disable the app.

On top of that:

• for people with old setups, there are probably a lot of unused tables (I think some were cleaned during update procedures). Is there a way to find out which tables are used/not used in my current setup?

[e-alfred]

This is a very important feature because there are so many apps that come and go, sadly. A database/filesystem littered with old unused stuff that might create problems/conflicts with other apps/newer releases of Nextcloud is just not a great situation.

Aside from that, it would also get rid of mangling directly with the database if an app misbehaves and has to be restored to a "clean" state (i. e. removing everything related to the app in the database/file system).

Anyway, before deleting something, the admin should be asked and a backup should be created in the file system somewhere of any deleted data (creating a dump of the table and a tarball with the files that were deleted). So, in case something important was stored in it, this wouldn't be lost. The only other option would be to restore the whole old installation from a backup and start it up somewhere (a virtual machine?) and grab the data. This would be a lot of work if only a certain table would have been deleted for example.

[AND51]

Oh yes, this would be very nice. I use my Nextcloud since version 9 and I always updated it, tested this app and that app... I would like to clean up my Nextcloud, but I don't know how. Installing a fresh Nextcloud is no problem. Transferring files with rsync is also easy. But then I ran into problems, because I don't know which tables and files hold the users, the IDs, hashed passwords, contacts, calendar ... and so on. So a migration-tool or a cleanup-tool would be useful.

I tried using php occ db:convert-type. In one of the github issues here and in the documentation I read that this command will skip some unneeded tables. But when I execute this command, it says, "cannot migrate from mysql to mysql".

So this command is only for migration vom sqlite to mysql.

[twocoolbeans]

Adding to this slightly (although is already known). The "oc_bruteforce_attempts" table appears to never be cleaned.

[MichaIng]

To keep this request alive, I would also love to see an ability to "purge" app data from database and data dir in case. Of course this requires a list of tables and files/dirs an app uses/creates.