...
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 Block
...
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
...
- Replace the database name with the name of the new database.
Code Block sed -i s/thaliaproto/thaliaunicode/g CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp
...
- Use pluto to change the Latin1 and non-standard
...
- text
...
- to
...
- Unicode
...
- encoding.
...
Code Block
...
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
...
- 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 Block rm CMS-PROTO-TH3.MIT.EDU-db-thaliaunicode-2008-09-03-15-37.sql.temp
...