Closed Bug 559997 Opened 12 years ago Closed 12 years ago

SUMO stage new: convert database to UTF8

Categories

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

All
Other
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: paulc, Assigned: tellis)

References

()

Details

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!
Blocks: 554210
Major pages in 24 hours, so lowering priority.
Severity: major → normal
Assignee: server-ops → shyam
What time on Monday would be okay? If it's later in the day I should probably re-assign.
(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.
Cool, punting back to server-ops. I don't think I'll be up that late.
Assignee: shyam → server-ops
Assignee: server-ops → tellis
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.