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?

FabienO · 14 Sep 2010 at 14:38

What method are you using to store the information into that DB?

shine · 14 Sep 2010 at 14:43

If you've looking to move the data folder and files elsewhere then its as simple as:

stop mysql
edit my.cnf with new data dir location
copy the data files to the new location
start mysql

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.

shine · 14 Sep 2010 at 15:43

What OS are you on?

Reza86 · 14 Sep 2010 at 15:56

Solaris 10

shine · 14 Sep 2010 at 16:48

Create a new my.cnf in the /etc directory.

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?

shine · 16 Sep 2010 at 23:10

MySQL looks for the my.cnf in /etc by default. So if its there it will use it.

Yes renaming one of the preconfigured ones will work.