Moving Mysql to /home directory, websites are fine but The MySQL server is currently offline.

Hi this is my first thread. I love cpanel so much, it brings so much convince.
Let me briefly introduce my situation here.

Due to reach /var limitation. I moved /var/lib/mysql to /home/data/mysql directory
and than I removed the mysql folder in /var/lib/
Websites all are fine, I can manager database from whm.
I can manager database from website backends by using Adminer in Joomla.
Server status in WHM shows Mysql is up.

ISSUE:
When I logined to cpanel,
All of database session are malfunctional.
Phpmyadmin cannot be loaded,
Mysql Database shows following error message:
The MySQL server is currently offline.
Mysql::initcache() failed: The mysql server is offline.

Attempt:
I did research and tried to reset password on mysql root and users.
And I tired use
# /scripts/checkperlmodules –full –force
# /scripts/upcp –force
None of above are working.


Could you help me find out how to solve this issue?

 

Hi Thank you for your reply.
I thought I messed up with some symlink or directory path. but the wired thing is all of my websites are fine.

I follow exactly the same way in instruction on move mysql to /home/data path

Code:

"
1. Stop MySQL
Before making any changes, first make sure to stop mysql service
refer to : - Removed -
# service mysqld stop

2. Change Data Directory
Now copy default MySQL data directory (/var/lib/mysql) to other location as per your requirement. Also set the required MySQL ownership on new directory location. As per below command, we are relocating data directory to /data/mysql.

# cp -rap /var/lib/mysql /data/mysql
# chown mysql.mysql /data/mysql

Now edit MySQL default configuration file /etc/my.cnf and update values of datadir and socketvariable.

Change From:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

Change To:
datadir=/data/mysql
socket=/data/mysql/mysql.sock

3. Start MySQL
After making all above changes. finally start MySQL service. Now it will use new data directory path

# service mysqld start
"

 

Problem solved. by adding symlink for /var/lib/mysql to point to /home/data/mysql.

Thanks all above =)