Import rt3 database

RT Users
1

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.

2

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.

3

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.