Am 13.10.22 um 15:29 schrieb Jogchum Reitsma:

Op 13-10-2022 om 15:10 schreef Reindl Harald:

There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem.

you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql

OK, so, to be quite sure, the command then is

mount --bind <the-location-the-database-resides-now> /var/lib/mysql

yes, the only difference to any other mount is type "bind"

OK, I've done so, and now

l /var/lib/mysql

reads, no surprise, the contents of the original db location.

In /etc/my.cnf I changed the location to /var/lib/mysql.

But, starting the database server still fails with the same error and warning messages:

okt 13 16:35:15 linux-mkay systemd[1]: Starting MariaDB database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░  
░░ A start job for unit mariadb.service has begun execution.
░░  
░░ The job identifier is 6638394.
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as process 92738 ...
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [Warning] Can't create test file /var/lib/mysql/linux-mkay.lower-test
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: [90B blob data]
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [ERROR] Aborting
okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░  
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░  
░░ The process' exit code is 'exited' and its exit status is 1.
okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░  
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
okt 13 16:35:15 linux-mkay systemd[1]: Failed to start MariaDB database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░  
░░ A start job for unit mariadb.service has finished with a failure.
░░  
░░ The job identifier is 6638394 and the job result is failed.

So nothing is gained so far...

regards, Jogchum

my /etc/fstab for /home while "/mnt/data/home" is the phyiscal location on a 4 TB RAID

/mnt/data/home /home  none  bind

i don't create bind mounts manually because you can mount, unmount and comment out them in fstab like every other mountpoint and i perfer them to survive reboots