This story is unavailable.

Hi Fred,

Great post, but I would have a comment. If using microseconds was not one of the reason for this upgrade (actually microseconds are introduced in 5.6.4 not in 5.7, but mysql_upgrade only forces this changes in 5.7) you could just skip the alter table part because MySQL 5.7 still supports the old date formats. So you can do an alter table prior the upgrade or you can just skip this part during the upgrade (the upgrade would be done only in a few minutes) and do the alter table later when you want. But of course with 22T data an alter table is going to take a while.

Like what you read? Give Tibor Korocz a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.