We're upgrading from Moodle 1.5.2 to 1.7.x, then to 1.8.x. The upgrade to 1.7 was successful (finally), but with more than 1.5 million total rows in the database, migrating the database to utf8 is taking waaay too long. The script has been running for ~90 minutes now, and it says it will end in 3 hrs. and 6 mins. Unfortunately, this estimate continues to increase.
After doing some digging, I discovered I'm not the only one to encounter this, with some reporting 3 days to complete the migration. What's really disturbing is the fact that, as I write this, it's converting a Long Blob field that has no data whatsoever in a table with 340,000 rows . Ouch!
Is there a more efficient way to do this?
The estimated completion time has risen another 13 minutes in the time it took me to write this....