Linux XAMPP - newb struggling to change MySQL DATADIR

Alles, was MySQL betrifft, kann hier besprochen werden.

Linux XAMPP - newb struggling to change MySQL DATADIR

Postby mrodent » 29. October 2010 17:38

Hi all,

Have worked out how to
- 1) rename /opt/lampp/var/mysql as mysqlbk
- 2) create a symbolic link placed in /opt/lampp/var called "mysql" which links to another directory somewhere else.

This works... but only if you do
# chown -R nobody [...]/mysql
on the new directory in question (i.e. where you want your data files kept).

So far so good... took me a bit of sweat to find out that mysqld under xampp is running in a process owned by "nobody".
BUT... in fact I want my database files to be kept on a Truecrypt volume... inevitably when this runs it runs in *somebody*'s Truecrypt process... so in fact even root finds it impossible to change the ownership of the directories and files in it to "nobody".

Consequently any attempt to use a symbolic link pointing to a directory in such a mounted Truecrypt volume means that mysql won't start.

Surely running a process like mysqld in a process owned by "nobody" is pretty bad security practice anyway !? Does anyone know how you go about running it in a "proper" process?

For that matter does anyone know how to configure xampp-mysql so you don't have to use a workaround symbolic link arrangement as described above? I.e. how exactly do you change the DATADIR??? It certainly isn't by changing stuff in \opt\lampp\etc\my.cnf, as I have found out this afternoon after several frustrating hours!

Posts: 5
Joined: 28. October 2010 19:20

Return to MySQL

Who is online

Users browsing this forum: No registered users and 3 guests