Move Mysql Other directory: help

valvps · Mar 12, 2018

Hi:

I'm following this manual to move the mysql directory

https://forums.cpanel.net/threads/how-to-move-mysql-data-directory.110481/

but there is something wrong

ln -s / home / mysql / var / lib / mysql
ln: failed to create symbolic link '/ var / lib / mysql / mysql': File exists

and in addition to finishing the steps, the database is still recorded in the old directory

KnownHost-DanielP · Mar 12, 2018

I'm going to assume /var and /home are two different mounts so you need more space and this is how you're accomplishing it.

So here's a quick list of commands for how I would accomplish this:

Code:

# Stop MySQL
systemctl stop mysqld
# Verify MySQL directory size
du -h --max-depth=1 /var/lib/mysql 
# Move the MySQL directory
mv /var/lib/mysql/ /home
# Verify the size has moved
du -h --max-depth=1 /home/mysql
# Symlink them
ln -s /home/mysql /var/lib/mysql
# restart mysql
systemctl start mysqld

You need to make sure the mysql directory in /var/lib is gone to symlink it to home so that might be the only step your missing.

valvps · Mar 12, 2018

hire the services of www.24x7servermanagement.com

and now no database works.

I'm waiting for it to be solved, and have my tickets respond.

there is some way to go back to the previous

some steps

and check var/lib/mysql no exist yet

KnownHost-DanielP · Mar 12, 2018

Does your data exist in /home/mysql ?

valvps · Mar 12, 2018

Yes

KnownHost-DanielP · Mar 12, 2018

All you should have to run then is the following command.

Code:

ln -s /home/mysql /var/lib/mysql

That will create the symlink, after that restart MySQL

valvps · Mar 12, 2018

KnownHost-DanielP · Mar 12, 2018

Ah, I missed the mysql@ in the other picture.

Try

Code:

rm /var/lib/mysql

Then try to make the symlink.

valvps · Mar 12, 2018

all the pages that use databases do not work.

those who use whcms leave this message

restart but same error

and error log mysql

KnownHost-DanielP · Mar 12, 2018

Hmmm, if MySQL is booting that's a good sign, but if no one can access it perhaps we have a permission issue.

So

Code:

cd /home/mysql
ls -lah

This will show the ownership and permissions of the folders and we can make sure everything is owned by mysql:mysql for user and group and has at least 700 permissions for db folders and 751 for the main mysql folder.

valvps · Mar 12, 2018

KnownHost-DanielP · Mar 12, 2018

Permissions look correct.

I'd say your next step would be to try and manually connect to the database.

So

Code:

mysql -u username -p 
# then
use valvps_whmcs;
show tables;

Replace username with your MySQL user and password with that db password. If that works then the problem is somewhere else, apache/php perhaps. If not then we've still got issues somewhere in MySQL

David Beroff · Mar 12, 2018

Seem KnownHost-DanielP is an web hosting expert here, why (valvps) don't send him server account and ask him to look into it and solve the problem directly? If he can fix it for you then you can reason or solutions that he used. That's better to ask via images

valvps · Mar 12, 2018

I did the test with another website that has whmcs and has the same problem

I see that it connects and lists the databases.

now if I do not understand why it does not work

KnownHost-DanielP · Mar 12, 2018

I'd say make sure to fully restart apache as it's possible something is hung up with the MySQL location.

Alternatively look for error_log files in your home directory that may give more detailed errors.

So for now

Code:

systemctl restart httpd

and try again.

valvps · Mar 12, 2018

This important ?

here

KnownHost-DanielP · Mar 12, 2018

Hmmmm,

Try this

Code:

chown -h mysql:mysql /var/lib/mysql

It could be the ownership of the symlink causing issues

valvps · Mar 12, 2018

Well, update Mysql to the latest version

and this has solved the problem.

I want to thank you for taking the time to help me

thank you very much.

Move Mysql Other directory: help

Active member

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Well-known member

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Sponsors

Tag Cloud