Hello,
I'm come across a situation where a table in our production DB has a
relatively small number of duplicative rows that seemingly defy the
unique constraint present on that table.
We're running MySQL 5.6.19a via Amazon RDS. The table in question is
~250M rows.
`show create table` give
There are several weird hybrid ways of installing MySQL on Mac (the native
install as provided by Apple, tar or dmg from Oracle, Darwin Ports, brew
and Fink, if the latter is still around) all of which are utterly mutually
incompatible. But once it is up, it's behaviour is the same as a typical
un
Yes, normally convert from latin1 to binary, and from binary to utf8 (which
would also be the recipe to convert actual utf8 data which accidentally
ended up in latin1 columns to the proper definition without changing the
content). I would not know why that would take overly long for you.
An altern
Hi there,
I am looking for a way to convert about 40GB of InnoDB tables from latin1
character set to utf8. As true conversion will take ages, I had the idea of
just changing the character sets (and preferably collation, too) of the tables
without actually converting the data. Conversion could b
