I have not much yet to say on a popular topic of upgrading everything to MySQL 8, so let me just continue reviewing public MySQL bug reports that I've subscribed to recently. After my previous post at least one bug, Bug #94747, got enough comments and clarifications (up to specific commit that introduced this regression pointed out by Daniel Black!) to have it re-classified and verified as InnoDB code bug. So, I see good reasons to continue attracting wide public attention …[Read more]
MySQL Workbench is a great tool for developers to map out and
visualise databases. What many people know is that it’s also a
great way to make upgrading and writing upgrade scripts for your
components really painless too.
Let’s say you created a small component that became popular over night. Tens of thousands of downloads from on the Joomla Extensions Directory. So you get inspired and put some more work into improving and bugfixing this component even more, and while doing that you change and add on to the database schema.
Now you need to create and distribute an update script with the next version of your component, and MySQL Workbench makes creating this update script really easy. Here is what you need to do:
Install MySQL Workbench
I’ll not help you with this. Just go to the MySQL Workbench homepage and follow the instructions from there. …[Read more]