Move backup location of mysqldump to volume

[girish]

@stevespaw you can symlink the /home/yellowtent/appsdata/appid to some external disk . Something like:

Stop the app
mv /home/yellowtent/appsdata/appid /mnt/volume/
ln -s /mnt/volume/appid /home/yellowtent/appsdata/appid
Start the app

Have a backup before you do this

[stevespaw]

OK I have done the above, But get an error when doing a backup.

[girish]

@stevespaw the directory has to be owned by the yellowtent user

[stevespaw]

OK now I will show my lack of linux. I did this all as root. What do I do now? How do I fix this permission issue? Thanks.

[andreasdueren]

@stevespaw said in Move backup location of mysqldump to volume:

OK now I will show my lack of linux. I did this all as root. What do I do now? How do I fix this permission issue? Thanks.

sudo chown -R yellowtent /path/to/directory

[girish]

For the backup issue atleast, -R is not needed. Just the top level directory and symlink has to be owned by yellowtent user

[stevespaw]

OK just to recap - This seems to be working on my test system. This is after I followed the steps for my VPS to add a disk and the Cloudron instructions to add a disk and a volume. I did this as root. I used the "disk" in place of "volume".

Stop the app

mv /home/yellowtent/appsdata/dfaa72b8-8c42-433e-a001-c9d58563379b /mnt/disk/matomo/

ln -s /mnt/disk/matomo/dfaa72b8-8c42-433e-a001-c9d58563379b  /home/yellowtent/appsdata/dfaa72b8-8c42-433e-a001-c9d58563379b

chown -R yellowtent /mnt/disk/matomo/

Start the app
This would be nice to automatically happen with a Cloudron tool.
I will post back and edit if I find any issues when doing this on the production.
Thanks for all of the help.

[stevespaw]

Coming back to this issues as I am getting errors on backups:

Feb 08 23:00:52 box:backuptask fullBackup: app automate.bb-content.media backup finished. Took 30.926 seconds
Feb 08 23:00:52 box:locks write: current locks: {"backup_task":null}
Feb 08 23:00:52 box:locks release: app_a1372b32-5ec8-4fb7-99cb-9e687c05eac5
Feb 08 23:00:52 box:tasks update 1745: {"percent":43.85714285714286,"message":"Backing up matomo.bb-content.media (3/4). Waiting for lock"}
Feb 08 23:00:52 box:locks write: current locks: {"backup_task":null,"app_a1fea9d3-2af1-4336-ba20-148ae80f1f4f":"1745"}
Feb 08 23:00:52 box:locks acquire: app_a1fea9d3-2af1-4336-ba20-148ae80f1f4f
Feb 08 23:00:52 box:tasks update 1745: {"percent":43.85714285714286,"message":"Snapshotting app matomo.bb-content.media"}
Feb 08 23:00:52 box:backuptask fullBackup: app matomo.bb-content.media backup finished. Took 0.004 seconds
Feb 08 23:00:52 box:locks write: current locks: {"backup_task":null}
Feb 08 23:00:52 box:locks release: app_a1fea9d3-2af1-4336-ba20-148ae80f1f4f
Feb 08 23:00:52 box:taskworker Task took 51.786 seconds
Feb 08 23:00:52 box:tasks setCompleted - 1745: {"result":null,"error":{"stack":"BoxError: Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'\n at Object.writeConfig (/home/yellowtent/box/src/apps.js:3089:15)\n at snapshotApp (/home/yellowtent/box/src/backuptask.js:339:16)\n at uploadAppSnapshot (/home/yellowtent/box/src/backuptask.js:350:11)\n at backupAppWithTag (/home/yellowtent/box/src/backuptask.js:391:11)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","name":"BoxError","reason":"FileSystem Error","details":{},"message":"Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'"}}
Feb 08 23:00:52 box:tasks update 1745: {"percent":100,"result":null,"error":{"stack":"BoxError: Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'\n at Object.writeConfig (/home/yellowtent/box/src/apps.js:3089:15)\n at snapshotApp (/home/yellowtent/box/src/backuptask.js:339:16)\n at uploadAppSnapshot (/home/yellowtent/box/src/backuptask.js:350:11)\n at backupAppWithTag (/home/yellowtent/box/src/backuptask.js:391:11)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","name":"BoxError","reason":"FileSystem Error","details":{},"message":"Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'"}}
Feb 08 23:00:52 BoxError: Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'
Feb 08 23:00:52 at Object.writeConfig (/home/yellowtent/box/src/apps.js:3089:15)
Feb 08 23:00:52 at snapshotApp (/home/yellowtent/box/src/backuptask.js:339:16)
Feb 08 23:00:52 at uploadAppSnapshot (/home/yellowtent/box/src/backuptask.js:350:11)
Feb 08 23:00:52 at backupAppWithTag (/home/yellowtent/box/src/backuptask.js:391:11)
Feb 08 23:00:52 at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

[joseph]

@stevespaw said in Move backup location of mysqldump to volume:

Feb 08 23:00:52 BoxError: Error creating config.json: EACCES: permission denied, open '/home/yellowtent/appsdata/a1fea9d3-2af1-4336-ba20-148ae80f1f4f/config.json'

Check the permissions of the directory. Does yellowtent user have permissions to write to it?

[stevespaw]

We decided to move this is a box with much more storage. I have done the backup and restore many times, no issue. But I have had this "mnt" with link working for some time now. BUT I did the backup and restore and realized that the external mount to another drive broke the Matomo restore. What do I do to get this back?

[joseph]

Can you explain better what is the error and what is the current situation ?