Can I setup a MySql database on a different partition from the MySql installation?

I have a server running Linux Red Hat 5 Enterprise with a basic, default installation. I would like to partition the HDs to separate my OS from database data. Now, after partitioning, should I reinstall MySql on the new partitions or can I configure it somehow to "point" to the new partition? Thanks!
salamandersockAsked:
Who is Participating?
 
pilson66Connect With a Mentor Commented:
From Unix view - mounted partition is like directory.
So, if you mount ppertition, you need set user, group and permissions in desired folder.
0
 
wolfgang_93Connect With a Mentor Commented:
0
 
salamandersockAuthor Commented:
Thanks you two! I will be trying this suggestions out.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Muhammad WasifConnect With a Mentor Commented:
Changing data directory is the most easy option. While using InnoDB you need to be careful. InnoDB data is usually saved in ib_log* files. You need to export InnoDB tables and then import to work InnoDB tables properly after changing data directory.
0
 
salamandersockAuthor Commented:
Thanks everyone, for the help! One more question, this may seem like a silly qustion, however, I have been asked to change the "name" to the partition? For instance, is there a way to rename the volume something like "DB" or "Database"?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.