Moodle 1.9.9 upgrade nightmare
Hello everyone, I hope someone can help with my current Moodle problem. . .
I upgraded from Moodle 1.9.5 to 1.9.9 using the moodle.org package. This also upgraded my server's PHP, Apache and mySQL, of course. I now find I cannot use my previous 1.9.5 database or moodledata folder.
The best I can manage is a completely new and empty install of Moodle 1.9.9, using the default database and moodledata folder. Any attempts to 'point' Moodle 1.9.9 at the 1.9.5 database and/or moodledata folder result in the dreaded 'Database connection failed. It is possible that the database is overloaded or otherwise not running properly' error.
mySQL can see the 1.9.5 database and run commands on it. Running mysqlcheck shows several tables as corrupt with the error 'Incorrect key file'. Using mysqlcheck's '--auto-repair --optimize' and mysql's 'repair' doesn't change this.
I should probably say I am running this on a Windows Server 2003 machine, which may surprise none of you. Please don't shout at me, I had nothing to do with that decision - I am merely the poor sap who has a broken Moodle just before the start of a new academic year.
Finally, apologies if the solution is elsewhere on here or t'internet in general. Trust me, I have looked, but as time has gone on and my brain has become ever more fried I may have missed it.