Need to Move MySQL/Databases to Another Drive

[dutton2]

We operate a Windows 2003 dedicated server and have two quite busy forum installs on them. Over the past few weeks, we have noticed the server is slowing at times. Our managed server support staff ran some tests and foudn that the MySQL is using up a lot of the IO and recommended that we move the MySQL to our E drive (which is pretty much empty right now).

I have never done this and am concerned about downtime or the loss of any data.

Can someone recommend a process to follow to ensure all goes correctly?

Thanks.

[AndyF]

Moving topic to "Server Management, Resources, Optimization" :)

[bfarber]

Sounds like your host should be able to do this for you. I'd imagine it wouldn't be that hard to do all in all. Shut the board offline (probably put up an index.html page to completely block it too). Move the mysql data directory as directed by your host. Shut down mysql service. Change my.cnf to point to new data directory. Turn on mysql server. Visit board/turn online to make sure it's working.

[dutton2]

Thanks -do you think I should move the actual install of MySQL too? I also only see a my.ini file in the MySQL directory. Would this be what you are referring to?

[bfarber]

You shouldn't have to move the mysql install - just the data (based on what your host is saying). Yes, that my.ini is probably the right file.