[rt-users] Import rt3 database

[Sean Perry]

Andrew Melton wrote:

> I have dumped  my rt3 database from an old RT 3.0.3pre server and want to
> import it into a new RT3.0.4 server.  
> 
> #mysqldump  -u rt_pass -p rt3 > /path/to/file/rt3dump.sql
> 
> That left me with a copy of my database. 
> 
> I have already installed 3.0.4, so I have an empty rt3 database on the new
> machine.  When I try and import the old database into the new one, I get an
> error that the ACL table already exists. 
> 
> Does anyone know the mysql command to import the old database into the new
> one?
> 

just do 'make dropdb' from the rt-3-0-4 source dir, then do:

mysqladmin -u root -p create rt3
and run your mysql < rt3dump.sql again.

In other words, kill the empty db, make a new one and then fill it.