Updating pid

by  |  07-Dec-2019 07:19

So, the procedure of moving My SQL databases to a "larger disk" on a system with SELinux on described below.Ok, I did it on a virtual machine, so my box is: VMWare Workstation 7.1.5 Cent OS 6.2 (x64) My SQL 5.5.21 I assume you want to move My SQL databases from its default location (/var/lib/mysql) to another disk mounted to /data, such that you new datadir would be /data/mysql So start your terminal and type shell commands (# - preceeds my comments, shell cp -rp /var/lib/mysql /data #Create by coping from some of the sample files provided with My SQL installation #I took "huge", you can take any one whichever suites your situation best: shell vi /etc/my.cnf) by fixing paths for socket file and adding datadir option into [mysqld] section and fixing . My SQL is not running, but lock file (/var/lock/subsys/mysql) exists #Error log is not updated at all ?

updating pid-5updating pid-79updating pid-55

mysql mysql system_u:object_r:default_t:s0 /data/mysql/ #See the difference ?

This difference causes the error message at My SQL startup. #Check, whether you have policycoreutils-python package installed.

Can you please provide the error in the mysql log which will help to resolve the issue.

It seems you have tried modifying some Inno DB options or one of the deprecated function and this is the reason mysql wont start.

But be careful: do not 121212 Inno DB: remove old data files which contain your precious data!

Community Discussion