I am working with a couple of legacy applications and I am trying to update all of their database collations to be utf8_unicode_ci. From my reading, this is my best bet.
I have found a couple of posts that help with this and it works fine for most of the tables. Note that I am assuming I need to update the database and tables. I can't just update the database collation.
I keep getting a query timeout error when trying to update the collation of large tables. It seems that the timeout is set to 10mins (600 seconds). I have investigated global variables and timeout variables, but I haven't managed to get anything working. I can't seem to find the correct variable to update so I can make this update.
See error below
Error Code: 2013. Lost connection to MySQL server during query
How should I go about getting this updated to work this? Is there a way that I can speed up this whole process of updating the collations?
Thanks.