559997 - SUMO stage new: convert database to UTF8

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Paul Craciunoiu [:paulc]]

We need to convert our SUMO database from latin1 (current) to UTF. Bug 554210 explains why we need this.

We have a script that converts every single Tiki table in attachment 438611 [details] [diff] [review].
This is expected to take a while to run, and it assumes there are no duplicate keys in any table. Chris went through and cleaned up all of the duplicates (hopefully), but, just in case there are problems, it would be good for a SUMO developer to be around when the script is run, so a good time would be Monday PDT.

Once the script is done, the database collation should be altered as well, so run this:
ALTER DATABASE `db_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Thanks!

Comment 1

[Jeremy Orem [:oremj]]

Major pages in 24 hours, so lowering priority.

Comment 2

[Shyam Mani [:fox2mike]]

What time on Monday would be okay? If it's later in the day I should probably re-assign.

Comment 3

[James Socol [:jsocol, :james]]

(In reply to comment #2)
> What time on Monday would be okay?

Afternoon would be best. That's when both Paul and I will be around, and I'd rather avoid a third late night in a row.

Comment 4

[Shyam Mani [:fox2mike]]

Cool, punting back to server-ops. I don't think I'll be up that late.