On Wed, Jul 16, 2008 at 10:09:52PM +0400, Ruslan Zakirov wrote: > Let's make it clear: > * you still must upgrade DB using files in etc/upgrade/x.x.x/ > * however in 3.8.0 you can do it using one command: > > rt-setup-database --dba root --prompt-for-dba-password --action upgrade > > it will ask for the old version (for example you can enter 3.6.7) and > will apply all steps up to the installed version (in this case it's > 3.8.0) > > * then you do mysql schema changes using the script > * these schema changes are required for all mysql versions greater > than mysql 4.1.0 >
I have some problems about this here: - I ran the 4.0-4.1 script on the DB, no errors - the rt UI display now weird caracters :( direct select on mysql command line looks ok - I looked at the original dump of my DB (before script), everything seems in latin1 - so I dumped with "--default-character-set=latin1 --skip-set-charset" and get a working dump in latin1 - I converted it with iconv to utf8 - then I did a new import in an utf8 db, with --default-character-set=utf8 - still weird characters, direct select on mysql command line looks ok - I added in Handle.pm a "SET NAMES utf8", now the rt UI is ok ... I'm a bit lost with MySQL encoding :( Any help there ? _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
