I would not recommend using either SMB or NFS to access data directories , especially if you expectingany kind of load. File locks simply do do work effectively (or at all) across such mounts.
- michael dykman On Tue, Apr 1, 2008 at 12:05 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > Option 1: > Assuming you do not need the databases to interact with each other I > would setup two instances of mysql with separate datadirectories. This > should make your back process easier. Read: > http://dev.mysql.com/doc/refman/5.0/en/option-files.html > http://dev.mysql.com/doc/refman/5.0/en/windows-create-option-file.html > > Option 2: > You could symlink (or NTFS junction for windows using a tool like > winbolic link) the data directories for the individual databases to > different locations. > > As for "One file per table" I don't think that is what you want/need. > http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html > "Using multiple tablespaces can be beneficial to users who want to > move specific tables to separate physical disks..." and you want to > move the whole database. > > > > > > > > On 3/31/08, Reuven Nisser <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I have two MySQL databases and I would like to place each one of them on > > a separated disk, and backup each one of them separately. > > > > > > I understand I need to use the "One file per table" option, right? It > > will effect all the databases. > > > > How do I place each database on a different volume? Do I use file link? > > How to do it on Windows platform? > > > > Thanks, Reuven > > > > > > > > > -- > Rob Wultsch > (480)223-2566 > [EMAIL PROTECTED] (email/google im) > wultsch (aim) > [EMAIL PROTECTED] (msn) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]