[rt-users] Problem upgrading database from 3.8.6 to 4.0.1 on Ubuntu 8.0.4(mysql)

[Thomas Sibley]

On 07/29/2011 08:55 AM, Wikus Smit wrote:
> We have upgraded from RT 3.8.6 (Ubuntu 8.0.4, Mysql,Posfix,Apache) to
> 4.0.1 but ran into a problem whilst upgrading the database. We created a
> new RT4 database with ‘make initialize-database’ and imported an rt3
> dump with ‘mysql -p rt4 < rt3.dump’.

Importing the RT 3 data into a fresh RT 4 database won't work.  Delete
the rt4 database and simply import your rt3 data into a new database
named rt4.  To put it another way, you're just making an exact copy of
your old rt3 database, but named rt4.  Don't run make
initialize-database.  Then run the upgrade steps, which will upgrade
your database.

You should start by reading our blog post
<http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html> and the
README included with RT.

Thomas