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

[Wikus Smit]

Thanks Thomas that worked! - we managed to upgrade to 4.0.1

Regards,

Wikus

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: 29 July 2011 15:48
To: RT Users
Subject: Re: [rt-users] Problem upgrading database from 3.8.6 to 4.0.1 on Ubuntu 8.0.4(mysql)

Please keep all replies on the list.

On 07/29/2011 10:44 AM, Wikus Smit wrote:
> I dropped the rt4 database and tried to import the rt3 database dump 
> with 'mysql -p rt4 < rt3.sql ' as suggested but received an 'ERROR
> 1049 (42000): Unknown database 'rt4'' error.
> 
> How can I import the rt3.sql dump file into mysql now that the rt4 
> database has been dropped?

This is basic MySQL administration.  Just create an empty database before hand with:

    create database rt4;

Thomas

--------
2011 Training: http://bestpractical.com/services/training.html