3 messages in com.mysql.lists.mysqlRe: Use Samba Share For Data Directory
FromSent OnAttachments
Michael Stearne25 Jan 2007 22:27 
Dominik Klein26 Jan 2007 01:02 
Michael Stearne26 Jan 2007 08:24 
Subject:Re: Use Samba Share For Data Directory
From:Michael Stearne (mste@entermix.com)
Date:01/26/2007 08:24:47 AM
List:com.mysql.lists.mysql

On 1/26/07, Dominik Klein <dk@in-telegence.net> wrote:

Michael Stearne schrieb:

We have 5.0.27 installed on a CentOS machine that doesn't have a ton of disk space. Is it possible to point the data directory to lie on a samba connected share? The samba share does not support Unix file permissions so it is not possible to set mysql as the owner of the files. Is this possible at all?

If you use proper mount-options, you can set the owner of the files.

mount -t smbfs -o uid=mysql $SHARE $DESTINATION

In general: This should not be a problem, but it will be slow as the network is propably slower than your local disc. Guess you knew that.

Yep. I'll try this . Thanks a lot!

Michael