Bill Karwin gives some insight into some work arounds when creating functions, triggers and procedures using Zend Framework; MySQL does support preparing some DDL statements, even in older versions. See http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html for lists of what statements can be prepared. However, some DDL statements are still not supported as prepared statements, for example CREATE FUNCTION, CREATE […]
Use this method if at all possible as it will attempt to recover non-English latin1 characters (accents, umlauts) in your existing data. Confirm your database is currently encoded in latin1. Make a fresh backup (ideally using mysqlhotcopy se notes below) Temporarily disable your cronjob so you don’t have anything trying to access the database. The steps below […]
Having covered the preparation and character set options of performing a latin1 to utf8 MySQL migration, just how do you perform the migration correctly. Complete story again at Migrating MySQL latin1 to utf8 – The process .
Mike Hillyer wrote a very good article on Managing Hierarchical data in MySQL, defenitely worth a read; Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a […]
Continuing on from preparation in our MySQL latin1 to utf8 migration let us first understand where MySQL uses character sets. MySQL defines the character set at 4 different levels for the structure of data. via Migrating MySQL latin1 to utf8 – Character Set Options
Before undertaking such migration the first step is a lesson in understanding more about how latin1 and utf8 work and interact in MySQL. latin1 in a common and historical character set used in MySQL. utf8 first available in MySQL Version 4.1 is an encoding supporting multiple bytes and is the system default in MySQL 5.0 via […]
Jayson Minard wrote a very good article on upgrading a production site and what can go wrong and what we can learn from it. Yesterday, I performed an upgrade to a third-party package used with Zend Developer Zone. It has an automated schema update system which silently performs actions on the database that had a large […]
Manually extracting relevant information from repeated incantations of SHOW ENGINE INNODB STATUS while trying to figure out what InnoDB is doing is not only error prone, it’s just plain hard to do. And since MySQL doesn’t expose the data you really want in an INFORMATION_SCHEMA table (yet?), the option is use an external program to help: innotop.
