I'm running Ubuntu 10.10 and I have already installed MySQL (default install using apt). I'd like to set up a database on an external USB harddrive, as it has a large amount of free storage. How can I achieve this? I have no idea where to begin!

Cheers,

Pete

link|improve this question

80% accept rate
USB 2.0 will be slow, MySQL will crash if the disk is not connected, hopefully ext. disk would not be formatted with FAT/NTFS fs. – jet Apr 4 '11 at 13:51
feedback

1 Answer

up vote 0 down vote accepted

Your best bet if you want 2 separate database storage areas is to run 2 separate instances of MySQL with 2 separate configurations.

Here's a good tutorial how to do it.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.