multiple file systems for mysql
How can I put mysql databases in different partition (linux - Ubuntu)?
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Create the new partition and filesystem. Mount it somewhere. Stop mysql and copy the entire contents of
You now have a few options (all assuming you mounted the new filesystem in
Whichever path you take, when you start mysql back up again it will be using the new location.