[rt-users] schema of the mysql-database suitable to RT 4.0.5

[Kevin Falcone]

Please keep list mail on the list.

On Fri, Apr 20, 2012 at 09:36:39AM +0200, Joerg Hollandmoritz wrote:
> As I mentioned already we have a fresh installation of RT 4.0.5. with
> only importing data from a former version. This was handled via
> mysql-export at the old version (3.6.3) and mysql-import in the new
> version (phpmyadmin).
> Then I made the following:
> " root at ultra:/opt/helpdesk.tmp# make upgrade-database
> /usr/bin/perl -I/opt/helpdesk/local/lib -I/opt/helpdesk/lib
> sbin/rt-setup-database --action upgrade --prompt-for-dba-password
> In order to create or update your RT database, this script needs to
> connect to your mysql instance on localhost as root
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> 
> Password: 
> Working with:
> Type:   mysql
> Host:   localhost
> Name:   DV_rt
> User:   dvATmysql
> DBA:    root
> Enter RT version you're upgrading from: 4.0.5
> The version 4.0.5 you're upgrading to is up to date.
> Done. "
> 
> How can I see the version of the schema of the mysql-database?
> How can I get the mysql-database properly running with RT ?

The command asked what version you're upgrading from, which you say is
3.6.3.  You'll need to enter that at the prompt.  You'll also
need to read and follow all other upgrade steps in docs/UPGRADING 3.6
3.8 and 4.0 as well as paying particular attention to
docs/UPGRADING.mysql

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120420/ed00ad0b/attachment.sig>