Having problems with moving nextcloud MySQL database files installed with snap
Hi, I have a bbox with LetBox (kind of like a slice and a slab from BuyVM sold together), and I installed nextcloud via snap (snap install nextcloud) on it. I have set the data directory to the block storage via symlink and currently havd around 15GB of files. However oc_filecache.ibd file was taking up like 8GB of storage. So this is what I did.
- Moved /var/snap/nextcloud/13144/mysql/nextcloud to /media/storage/nextcloud/mysql
- Added a symlink ln -s /medua/storage/nextcloud/mysql nextcloud
- Add this line to /etc/apparmor.d/tunables/alias
alias /var/snap/nextcloud/13144/mysql/nextcloud/ -> /media/storage/nextcloud/mysql/,
- systemctl restart apparmor
- snap enable nextcloud
And I got this
Internal Server Error
The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.
I also tried systemctl stop apparmor but still got the same issue.
This is part of php_errors.log file which seems to indicate a sql error, but I failed to find the mysql log file. Any help would be awesome. Thanks!