1
1-mehmeh
Guest
Greetings,
I am attempting to move my MySQL database files, literally. I am not exporting my database to another server. I am moving the files themselves to another location on the same box
I also want to change the path to mysql.sock
Ive moved everything into /mysql and edited /etc/my.cfg accordingly.
Unfortunately, I see two things happening.
1. Despite the fact that I have also changed the path the mysql.sock inside the same /etc/my.cfg, certain items are still attempting to connect via the old socket location, and 2., this is occurring:
My /etc/my.cfg is edited properly, has the right paths, ..the directory that is holding the files is owned by mysql/mysql and has the proper permissions.
Ideas?
I am attempting to move my MySQL database files, literally. I am not exporting my database to another server. I am moving the files themselves to another location on the same box
I also want to change the path to mysql.sock
Ive moved everything into /mysql and edited /etc/my.cfg accordingly.
Unfortunately, I see two things happening.
1. Despite the fact that I have also changed the path the mysql.sock inside the same /etc/my.cfg, certain items are still attempting to connect via the old socket location, and 2., this is occurring:
Code:
Starting xinetd service... done
Starting named service... done
Starting mysqld service... done
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database
System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database
System error 2: No such file or directory
My /etc/my.cfg is edited properly, has the right paths, ..the directory that is holding the files is owned by mysql/mysql and has the proper permissions.
Ideas?