Where is the database password stored in backups? about nextcloud-snap HOT 6 CLOSED

Can you expand on what you're trying to do, here? Do you just want to restore a backup? Or are you wanting to poke at the database on another machine? The backup generated by nextcloud.export is just a mysql dump of the nextcloud database. It doesn't really have a concept of users. When you install a new instance of the snap, it'll generate its own root (and nextcloud user) passwords, and then you'll be able to nextcloud.import your backup. Assuming all you care about is importing your backup, you shouldn't need to care about users at all.

from nextcloud-snap.

poking around too...

try
user: nextcloud
pwd: system-root-user-password

from nextcloud-snap.

Thank you two, that was a misunderstanding on my end. I was able to import the database to my personal machine by using the following commands:
sudo mysql
create database nextcloud;
exit
sudo mysql -u root -p nextcloud < /path/to/database.sql

I've already created a new nextcloud instance without the use of my backup. My intent is to export the calendar, contacts, and notes tables from my old database and import them into my new database.

from nextcloud-snap.

No problem, that's what this issue tracker is all about! Yeah I'd say you're on the right track here. nextcloud.mysql-client will probably prove useful to you. Just remember it will only be able to access /var/snap/nextcloud/current under confinement, so if you shave off smaller table dumps to import in pieces, make sure you put them in there.

from nextcloud-snap.

For anyone who might stumbled across this post via a search engine, I ended up creating a new snap nextcloud instance and did a backup import (without data). I then used the calcardbackup script with the -p flag and it worked great!

https://codeberg.org/BernieO/calcardbackup

from nextcloud-snap.

Awesome, thanks for the update @Matth3wW!

from nextcloud-snap.