MariaDB change datadir

[Vin]

Hello everybody,

 

I´m appareantly not capable of changing the datadir of the mariadb installation.

I googled it and followed several tutorial, yet I cant make it work.

 

Example

https://www.tecmint.com/change-default-mysql-mariadb-data-directory-in-linux/

 

I change the settings in this file /etc/mysql/mariadb.conf.d/50-server.cnf and i added under following sections the new datadirs/sockets

 

[mysqld]

datadir=/srv/dev-disk-by-id-ata-SanDisk_SDSSDH3_2T00_210837801141-part2/Medien/Programme/MariaDB

socket=/srv/dev-disk-by-id-ata-SanDisk_SDSSDH3_2T00_210837801141-part2/Medien/Programme/MariaDB/mysql.sock

 

[client]

port=3306

socket=/srv/dev-disk-by-id-ata-SanDisk_SDSSDH3_2T00_210837801141-part2/Medien/Programme/MariaDB/mysql.sock

 

Also i change the owner of the folder

chown -R mysql:mysql /srv/dev-disk-by-id-ata-SanDisk_SDSSDH3_2T00_210837801141-part2/Medien/Programme/MariaDB

 

and changed the path of the socket in those files under /etc/mysql/conf.d/ and /etc/mysql/mariadb.conf.d/

 

After i get those error messages

Warning: skipping '!includedir /etc/mysql/conf.d/' directive as maximum includerecursion level was reached in file /etc/mysql/mariadb.cnf at line 22
Warning: skipping '!includedir /etc/mysql/mariadb.conf.d/' directive as maximum includerecursion level was reached in file /etc/mysql/mariadb.cnf at line 23

 

Did anybody make it work with armbian?

 

Best Regards

 

Vin

[Werner]

There should not be any difference since this is userspace and Armbian does not touch/modify mariadb packages in any way. Armbian puts a userspace environment (Debian Bullseye, Ubuntu Focal) with minimal adjustments for performance on top of a working kernel for the specific hardware.

 

Besides all of that it would be interesting to know on which hardware you are actually working on and

  

Providing logs with 

armbianmonitor -u

 helps with troubleshooting and significantly raises chances that issue gets addressed.

[Vin]

Hi Werner,

 

thanks for your reply, and sorry for not directly adding logs.

 

I´m on a Helios64 Buster Image

 

http://ix.io/3Fh9

 

[Vin]

Nobody any idea how to move the datadir correclty?