hi folks
right now I have the default mysql configuration, thats why my data folder is over the /var/ partition,and since this partition is keeping without free space, I wanted to move my data folder.
when I try to stop my mysql server I got:
so I figured out that mysql I being started by Cpanel ? but adding few parameters:
I'm concern about if I make the data folder move and I don't change those parameters mysql wont start again.
I've been reading all FAQ's and docs about cpanel and I couldn't found any info regarding steps I should follow to modify those scripts.
or just I need to change the /etc/my.cnf and Cpanel will detect the changes?
any help will be appreciated
right now I have the default mysql configuration, thats why my data folder is over the /var/ partition,and since this partition is keeping without free space, I wanted to move my data folder.
when I try to stop my mysql server I got:
Code:
[[email protected] ~]# service mysql stop
MySQL manager or server PID file could not be found! [FAILED]
[[email protected] ~]#
Code:
[[email protected] lib]# ps aux | grep mysql
root 2701 0.0 0.0 2420 1092 ? S Jan21 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxxx.pid
mysql 2725 0.1 0.4 124448 26660 ? Sl Jan21 89:17 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/xxxx.pid --skip-external-locking
I've been reading all FAQ's and docs about cpanel and I couldn't found any info regarding steps I should follow to modify those scripts.
or just I need to change the /etc/my.cnf and Cpanel will detect the changes?
any help will be appreciated