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!

  • 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, 2011 at 13:51

1 Answer 1


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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .