I am migrating a LAMP system from a Ubuntu 14.04 droplet to a Ubuntu 20.04 droplet. Most of my problems seem to be involved with moving from mysql 5.5.60 to 8.0.25. I’ve identified two main problems so far:
These two problems interact in absurd ways. For example, an attempt to alter a column to add a default value fails with an error complaining that existing records contain zeroes in a date:
mysql> alter table meetings modify column meetMpgmKey int default 0; ERROR 1292 (22007): Incorrect date value: '2004-05-00' for column 'meetBeginDate' at row 50
More generally, is there a guide to upgrading to mysql 8 that covers issues like this?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
You can find the MySQL config file here:
After making the changes make sure to restart MySQL so that the new changes could take effect.
Not 100% sure if there is an article out there that covers all possible problems, but here is a very good summary on the official MySQL website summarizing the new changes with MySQL 8: