Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
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
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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