MySQL with alternative datadir

elflesnoy · 12-22-2010, 05:53 AM

Hello!

After several hours of searching web I give up.
Problem: I want to run mysqld with datadir option

When I run it manually without --datadir everything is fine

I have added required lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor

Quote:

/sys/devices/system/cpu/ r,
/disk0/mysql r,
/disk0/mysql/** rwk,

Then I copy /var/lib/mysql to my location, carefully, 10 times checking all the permissions and run. But daemon exits immediately after running.

Quote:

sudo mysqld_safe --datadir=/disk0/mysql --user=mysql
101222 11:29:46 mysqld_safe Logging to syslog.
101222 11:29:46 mysqld_safe Starting mysqld daemon with databases from /disk0/mysql
101222 11:29:47 mysqld_safe mysqld from pid file /disk0/mysql/d-st-n1.pid ended

I go to check syslog and see nothing

Quote:

Dec 22 11:29:46 d-st-n1 mysqld_safe: Starting mysqld daemon with databases from /disk0/mysql
Dec 22 11:29:47 d-st-n1 mysqld_safe: mysqld from pid file /disk0/mysql/d-st-n1.pid ended

Any ideas ?

paulsm4 · 12-22-2010, 10:09 AM

If you haven't already, please look in your Mysql log, too:
EXAMPLE: /var/log/mysqld.log

Also check the syntax in your my.cnf configuration file:
EXAMPLE: /etc/my.cnf

Code:

[mysqld]
datadir=/opt/mysqldata
...

This link might help:
http://docdb.fnal.gov/doc/my.cnf.html

TheGorf · 12-22-2010, 01:58 PM

What distribution are you running? It's possible you are running into SELinux permissions issues. You can test that option easily by using the "getenforce" command:

Code:

[gorf@dlsrv01 logrotate.d]$ getenforce
Enforcing

That tells me that my local system is using SELinux and is enforcing. If that's true, then the simple test is to temorarily turn it off:

"setenforce Permissive"

Then try to restart your MySQL process.