I'll see soon. I've reinstalled Fedora 31 Server from scratch. I'm using newer and stronger certificates following those two guides:
https://linuxize.com/post/secure-apache-with-let-s-encrypt-on-centos-8/
https://riegers.in/nextcloud-installation-guide-ubuntu-18-04/
Next step is to restore Nextcloud DB and get Nextcloud up and running again. I'm not working with the server every day, that's why it takes some time 
Best regards,
Woti
The permissions has been changed before. As I wrote in the beginning thread the entire filesystem has been changed to 777.
I could fix it via the rpm command but that command can just fix default files and folders, no user files and folders.
To backup the database I used this command as recommented:
mysqldump --single-transaction -h localhost -u nextadmin -pnextcloudPassword nextcloud > /mnt/cloud/Nextcloud-DB_`date +"%Y%m%d"`.sql
Is there anything new with updating the script?
Hello again
I did a backup og my MariaDB. But I saw under /var/lib/mysql are a couple of folders and files and all of them got permissions 777.
I mean shouldn't it be 640?
When I did the backup of the Nextcloud DB are the (wrong) permissions stored too?
These are the 5 folders:
/.rocksdb
/#rocksdb
/mysql
/nextcloud
/performance_schema
Can you guys be so kindly and check what are the right permissions for /var/lib/mysql folder and subfolders I wrote about?
I just wanna be sure before I delete everything
Best regards,
Woti
I've decided to install my Server from scratch.
I am wondering about:
How to backup and restore both MySql and Nextcloud content?
/data directory is located on a separate partition.
Is it possible to restore user credentials?
Is there some Fedora / CentOS based howtos?
Any help is very appreciated.
Best regards,
Woti
Thanks for the reply. I just thought, maybe it would be easier to setup.
I asked in Nextcloud Facebook group which one is better integrated in the mobile app to edit documents on mobile devices too. The most ones recommendet Collabora.
Google searches gave me a lot of Ubuntu / Debian baset howtos which drove me crazy to realize it in Fedora.
Hello from Norway
Born and grew up in Germany then moved to Norway. Nothing special to say about me. 
Best regards,
Woti
@DustinB3403 Yeah it is offline. I got back my access to root and user account. Thanks for the link. Interesting stuff
Would it be possible to include Collabora Online Office as selectable option?
Some thoughts about the To-Do list at the end of the script?
##################################### # #
ToDo
Hello guys,
I stumbled over this side when I was searching about restoring Fedora filesystem permissions and how to backup and restore Nextcloud content.
I don't know how I got it done to change the whole filesystem permissions from standard to 777. I lost my root and user access too.
I got some information about to use those commands:
for p in $(rpm -qa); do rpm --setperms $p; done
for p in $(rpm -qa); do rpm --setugids $p; done
I lost my root and user access but I'd fix it with Fedoras rescue mode.
All the rpm packages are fixed as much I can see it but there are a lot of key files and files / directories which aren't fixed.
The Nextcloud data directory is untouched, it is mounted on a separat partition but the whole Nextcloud in /var/www/html/... has 777 now. I could fix this back to the right permissions, but anyway I have a feeling about that my system became unsecure.
My questions are:
Any help is appreciated.
Beste regards,
Woti
Hei,
Is there no update of this script to work with Fedora 31 and Nextcloud 17?
Best regards,
Woti
