Are there any issues that I should be aware of if I try to move my version 4 database to the version 5 of MySQL?
I am asking this as I have had a copy of my database dropped onto a 5 server and I am having odd problems, which I was able to get around, (sort of) by commenting lines out in the inc_header.asp file, odd lines like the subscription code and the PM code. I am not too worried about that as I just want to get it up and running to see the response times.
There are some incompatibilities, but you should be able to do it with some simple changes, like the one in the Sticky by JiveMiguel in this forum and the changing of some variables from int to double (at least in the totals table).
Yes that change suggested by JiveMiguel was a significant improvement. Thank you.
Variables? My coding is not that fantastic, could you expand on this a bit? Should I be looking for a variable called INT and change them/it to DOUBLE ?
Ok, I have made the move to MySQL5 It went very smoothly and the board is running without error. I will continue to monitor.
Background... I was forced to move to the 5 box as there was something wrong with the 4 server and my hosting company just never got to the bottom of it, the speeds would be blazing at times and then to a snails pace (5 minute waits) on other times. The servers are just database servers... anyway after much conversation it was just easier for me to make the move.
I have tested everything through the menus and so far I have not found an issue. Please if anyone has a "heads-up" do let me know. My site is well mod'd; one thing I have use for some time now on a monthly basis is the script that ruirib wrote for the forum topic counts, am I ok to continue using that script?
Topic Locked
Posted - 19 April 2008 : 01:04:18
