MariaDB change datadir


Vin
 Share

0

Recommended Posts

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

Link to post
Share on other sites

Donate and support the project!

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

0