mysql data installed to /home/mysql

wtptrs

Verified User
Joined
Jul 13, 2015
Messages
74
I finished a Directadmin installation on a fresh Debian 10 server, thinking mysql data would be installed to /var/lib/mysql, with a symlink /home/mysql -> /var/lib/mysql as detailed here:


and as is the case on several Debian 9 servers we're running. I created a large /var partition because of this, but noticed mysql data is instead installed to /home/mysql:

Code:
# ls -l /usr/local/mysql/data
lrwxrwxrwx 1 root root 11 Jan 20 13:06 /usr/local/mysql/data -> /home/mysql
# ls -l /home |grep -i mysql
drwx--x--x 5 mysql   mysql    4096 Jan 20 16:46 mysql
Also, there is no mysql.sh script present in /usr/local/directadmin/scripts/ .

Is this specifically related to Debian 10? Will this cause any problems and am I better off reinstalling Directadmin on Debian 9?
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,766
Location
LT, EU
If you shut mysql down, you could simply do this then:
Code:
mv /usr/local/mysql/data /var/lib/mysql
ln -sf /var/lib/mysql /home/mysql
 
Top