[rt-users] Import rt3 database

[Ruslan U. Zakirov]

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?
>
>Thanks.
>  
>
You've done slightly wrong dump of DB. You have to add --add-drop-table 
or --opt (include drop flag and also other perfomance flags).
`man mysqldump`.