[SOLVED] QUESTION: Permissions for storing MariaDB data on a USB drive

[richardjlyon]

Hello. Novice user here.

I have an ubuntu-22.10-standard_22.10-1_amd64 LXC running mariadb, stored on the `local` SSD drive that proxmox is installed on.

I want to store the database on an external usb drive, accessible at path /mnt/gdrive/mariadb.

I've updated /etc/mysql/my.cnf as:

[mysqld] datadir=/mnt/gdrive/mariadb

PROBLEM: I cant restart the mariadb service, and attempting to move the database files from /var/lib/mysql to /mnt/gdrive/mariadb produces "permission denied" errors, even as root.

I presume I have to set a user up on /mnt/gdrive/mariadb - I assume a dedicated mariadb user - and give it read/write permissions, but I'm a novice Linux/proxmox user and don't know how to do it or where to look.

May I ask someone to advise me on how to set Mariadb with its database on an external USB drive in this way?

Thank you.

 

[LnxBil]

Besides that I do not recommend to run anything from external usb drives (latency-related issues) it may be easier to add the external disk as a new storage in PVE and just move your LX(C) container to the external storage. This is completely transparent to the container and will maybe work better with regards to your problem.

 

[richardjlyon]

Besides that I do not recommend to run anything from external usb drives (latency-related issues) it may be easier to add the external disk as a new storage in PVE and just move your LX(C) container to the external storage. This is completely transparent to the container and will maybe work better with regards to your problem.

That makes sense. I've purchased an external SSD drive and will follow your guidance. Thank you