Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 25, 200816 yr 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.
February 25, 200816 yr 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.
February 25, 200816 yr 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?
February 26, 200816 yr 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.
Archived
This topic is now archived and is closed to further replies.