Updating to 3.6.1, and migrating the database

RT Users
1

Hi, all –

I’m working on upgrading from RT 3.4.4 to RT 3.6.1. At the same time,
I’m moving to a different server, and a different version of MySQL on
the backend.

I think that the upgrade path needs to go something like this:

  • On the old server, dump the current (3.4.4) database from MySQL (v.
    4.1.10a).
  • On the new server, restore the 3.4.4 database into MySQL (v.
    5.0.18-max).
  • Run sbin/rt-setup-database --action [schema/insert/acl] --datadir etc/upgrade/3.5.1/ ...
  • Setup perl/apache/etc.

Now, I’ve got most of this working fine, but I’m actually having trouble
with the database migration.

Specifically, I’m losing/corrupting the binary data in the Attachments
table.

Can anyone give me a quick pointer on how to properly dump the rt
database so that binary data is maintained?

Thanks!

  • Ian
2

Hi Ian

I’m working on upgrading from RT 3.4.4 to RT 3.6.1. At the same time,
…
Specifically, I’m losing/corrupting the binary data in the Attachments
table.

http://rt3.fsck.com/Ticket/Display.html?id=6655
http://bugs.mysql.com/bug.php?id=10249

Cheers.