Backup contacts and calendar from database

ℹ️ Support
1

Hello, I automatically back up my files to a USB stick every day. I also want to back up the data from the calendar and address book. Are these stored in a database? If yes, where? I want to back them up every day. Many Thanks.

2

You could use calcardbackup to backup calendars and addressbooks.

2 Likes
3

Would it still be interesting to know where the data is stored?

4

Its in the database table {prefix}_cards

5

Hello Matti,

Yes these infos are in the database, I recently restored a crashed
database from a dump, I got all my contats and events.

I dunno precisely which tables. But a good practice is too backup the
whole database :

$ mysqldump -unextcloud -p nextcloud >
nextcloud.dailydump.sql | bzip2

Hope this helps,

Xavier

1 Like
6

calcardbackup uses these tables to backup calendar and addressbook data:

oc_addressbooks
oc_calendars
oc_calendarobjects
oc_calendarsubscriptions
oc_cards
oc_dav_shares
oc_group_user

Please note, that your table prefix might be different from oc_.

1 Like
7

Many Thanks. Can I change the backup path? I once adjusted the script, but it gives me a lot of errors. I want to change the “backupfolder”. Is it that easy?

8

Use the option

-o /PATH/TO/BACKUPFOLDER

You may want to have a look at the repos README for a quick howto, additional options and examples.

9

OK thank you

10

Hello, How can I copy the files back from the calendar?

11

I don’t quite understand. Do you want to reimport the backed up files to Nextcloud?

12

Sorry that I answer so late, I meant how I can take the saved Contacts.vcf back into the Nextcloud?

13
  • either upload the vcf to your Nextcloud and then click on it - it will be imported to the contacts app
  • or import the vcf into the contacts app of a carddav-client. The client will then sync the imported contacts to your Nextcloud
1 Like