[rt-users] Database Upgrade Errors -- Please Help

[Jennifer I. Moore]

Hi Ruslan,

Thank you for the steps below.  And for the NOTE of caution about breaking 
the upgrade scripts.  Very helpful.

I tried this approach on a development server running RH4, and the upgrade 
scripts ran without errors.

Unfortunately, apache is not finding the RT htdocs on that machine, so I 
haven't been able to test results yet.

I will try these steps on the server I'm building for our upgrade next 
week.  They wanted me to test RH4 first.

Thank you again,
Jennifer

At 11/22/2005 04:14 PM, you wrote:
>I think you have to do next steps:
>1) get new server
>2) resolve RT 3.4.4 dependencies on the new server
>3) run `configure --...; make install` this will install RT's source code
>4) configure RT_SiteConfig
>5) dump DB from the old server and restore it on the new with DB's
>tool (mysqldump)
>6) create mysql user with credentials the same as in RT_SiteConfig
>(option $DatabaseUser, $DatabasePass). Use mysql tools for this step.
>7) run DB upgrade scripts
>
>*NOTE:* you don't need to run `make initialize-database` on the new
>server from 3.4.4 tarball dir, because this will break upgrade
>scripts.