The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Moving to the Default Directory

Is there a web page which describes the proper steps to move the default directory from /var/lib/mysql to another directory?

I find steps by querying google but they seems incomplete. I get the following error message when moving both my

datadir=/home/maria/mysql socket=/home/maria/mysql.sock

all data from /var/lib/mysql was also copied to /home/maria/sql

Upon restart I get the error below

Database MariaDB is not initialized, but the directory /home/maria/mysql is not empty, so initializatio Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Control process exited, code=exited status=1 Jan 17 06:47:01 BillLaptop systemd[1]: Failed to start MariaDB 10.2 database server. Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Unit entered failed state. Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Failed with result 'exit-code'.

Answer

Hi,
you could use one of these tutorial for example:
- https://www.tecmint.com/change-default-mysql-mariadb-data-directory-in-linux/
- https://www.digitalocean.com/community/tutorials/how-to-change-a-mariadb-data-directory-to-a-new-location-on-centos-7

But please first read this official documentation to be sure you understand the configuration system variables: https://mariadb.com/kb/en/library/server-system-variables/#datadir

Regards,
Faustin

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.