Changing MySQL data path?

Reza86 · 14 Sep 2010 at 14:22

To change the location that database data is stored in MySQL do I need to create my.conf and then edit it or can MySQL be told to store the data somewhere else by another method?

Reza86 · 14 Sep 2010 at 15:31

What if I can't find my.cnf? I've looked in all the suggested directories, I can only imagine it either doesn't exist of the guy who installed MySQL had it in another location.

Reza86 · 14 Sep 2010 at 15:56

Solaris 10

Reza86 · 16 Sep 2010 at 08:57

If I do create a new my.cnf, how will MySQL know to look for it?

I have some copies of my.cnf-small, large etc that came with the MySQL 5 installation, I take it that just taking the size off of the end and editing my own details into these configuration files would work?