Change datadir in my.cnf

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I would like to move my DBs in another directory.
I know that I have to change in my.cnf the datadir path ....


-> datadir=/user/mysql/databases

now my question is, can I simple copy all my DBs to the new datadir,
and then restart mysql server ?
Or is there something to take care ?

Thanks a lot

Re: Change datadir in my.cnf wrote:
Quoted text here. Click to load it
It's pretty straightforward, the big thing is to make sure permissions
are set appropriately in the new location.  Here's one of many

Site Timeline