Archive:Fixing text encoding corruption

Here's what I did.


 * 1) freeze writes to the main wiki
 * 2) Dump freecult_wikidb to dump.sql
 * 3) Create a fresh MW install (just for the table schemas) in freecult_wikidb2
 * 4) Create a temporary empty DB, and import dump.sql to it
 * 5) In the temporary DB, ALTER TABLE on the text table so it has the same columns as freecult_wikidb2's text table
 * 6) Dump wikidb3 and have certainty that the column names will line up (but don't copy the sucky old schema)
 * 7) * mysqldump --no-create-info --add-locks --complete-insert freecult_wikidb3 > sql
 * 8) Import that into freecult_wikidb2, skipping the tables that are missing
 * 9) * mysql -f freecult_wikidb2 < sql
 * 10) * WATCH for errors other than "skipping missing table"
 * 11) php maintenance/rebuildall.php
 * 12) * If this fails with key errors, just drop the recentchanges table and recreate it with the wikidb2 schema