Estract or export tables of oc_activity.ibd to any file ? is possible?

ℹ️ Support
,
1

anybody help extract all activitys this file to any file format ?

thks…

2

I’m not sure what you are trying to achieve… what is wrong with running a select statement against your database?

show 10 records with postgres

select * from oc_activity limit 10

you can use psql or any other tool which can run sql queries.

1 Like
3

I don’t know the ‘any’ file format.

… but what I know, because of the file-ending ‘.ibd’ is that it is from a MySQL/MariaDB Database (no PostgreSQL).
The normal Interfaces for your database are ‘mysql’ and ‘mysqldump’

  • with mysql you can talk in SQL Language with your database. If you know what data you exactly needs, you can create the query that gives you all the data in the form you need.
  • with mysqldump you can create a dump of your table. You can read that dump with a text editor of your choice.

So all very simple basic tasks that everyone should be able to do and actually have nothing to do with Nextcloud it self.

If you would explain a little better what exactly you want to achieve, then you can be helped better, whether it’s Nextcoud or just basic knowledge of how to use your server, but you’ll have to put in a little more effort in your information.

Much and good luck,
ernolf

4

Good afternoon, thanks for the answer, I’m Brazilian and I work in IT, I’ve been using nextcloud for about 3 years, my idea would be to extract or export all activity from the files to another file format and leave it saved, in this file there are dates and times when they were added and modified files, thanks WWE

opening the file in notepad the information looks like the image below

image

5

.ibd stands for “InnoDB Data File” and is not in a human readable ascii format. Therefore you need the tools explained above.

Boa sorte,
ernolf

1 Like
6

when I said any extension I meant .txt .xls etc…

thks ernolf

7

as @ernolf explained you can not directly read/access .idb files but you can access the database using different tools.

another option and maybe simpler option to collect data you are looking for is admin audit log auditlog which can be optionally enabled and holds access information like create/access/delete files and many others… if you are looking for usage tracking this one likely better fits your needs.