On Tue, Sep 15, 2009 at 11:54 PM, Justin Hayes <[email protected]> wrote: > Hi guys, > I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup-database > fine: > > /opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support > --prompt-for-dba-password --action upgrade > > Then created the schema upgrade script: >
[snip] > Now that looks a bit odd as there are 2 ALTERS per table and the second > seems to reverse some bits of the first? It's not reverse, but metadata change about tables without changing the data. It's documented way to change character sets in mysql without changing data. > Anyway I ran that into my DB. Now when I go into a ticket with an image > attached and click on it no image is returned, which is a bit worrying. > I'm wondering if it was a problem with the upgrade, or the original db dump > provided by my IT systems guys. Perhaps the DB wasn't dumped using binary As you're pretty sure that you applied the schema change then it's problem with backup and restore. > character set? How could I check that and how should the IT guys have dumped > the DB to make sure it was in binary? mysqldump --opt --default-character-set=binary rt3olddb > backup.mysql.dump mysql --default-character-set=binary rt38newdb < backup.mysql.dump > Any thoughts? > Justin > ------------------------------------------------- > Justin Hayes > Orbis Support Manager > [email protected] > > > > > _______________________________________________ > 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 > -- Best regards, Ruslan. _______________________________________________ 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
