Note:  This is currently an outline, and should be scripted later.
# Stop the Thalia IME front end and the Alfresco repository server.
# Perform a dump of the MySQL database, using map-backup.py.
# Use sed to replace the declaratives for Latin1 to UTF8 in the sql file.
{code}
sed s/latin1/utf8/g CMS-PROTO-TH3.MIT.EDU-db-thaliaproto-2008-09-03-15-37.sql > CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp
{code}
# Replace the database name with the name of the new database.
{code}
sed -i s/thaliaproto/thaliaunicode/g CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp
{code}
# Use pluto to change the Latin1 and non-standard text to Unicode encoding.
{code}
cat UTF-8 CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp | pluto -c > CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql
{code}
#* Pluto is not install by default on server ops systems.  It is available on Trogdor, and will need to be built, suggested to do this on a office desktop, and scp the sql files there and back again.
# Remove the temporary file.
{code}
rm CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp
{code}