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

[Thomas Sibley]

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