Page History

# 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}