Fw: rt2.ACL does not exist

Yep, I did that. Could it be something happened with the dump? I will try to
do a new one. I followed the previous instructions of dropping the rt2 db,
recreating rt2, then doing a mysql -u -p rt2 < rt2.sqlschema

Am I missing something?

----- Original Message -----
From: “Jesse Vincent” jesse@bestpractical.com
To: “Raymond Norton” ray@lctn.k12.mn.us
Cc: rt-users@lists.fsck.com
Sent: Saturday, December 22, 2001 12:54 AM
Subject: Re: [rt-users] rt2.ACL does not exist

you need to make sure you import the schema before you import the dump.
(or you can do a full dump of them both together)

I have done a search and cannot find this posted before
I have done a new RT install and want to import rt2 database from
another

server. I have used mysqladmin to remove the rt2 database from the new
server (which was blank)

. I am doing a mysql -u root -pxx rt2 < rt2.sqlschema and rt2.sqldump.
I

mysqldump -a rt2 #on the first host should create a single full unified dump you can restore from successfully
using the drop/create procedure I described before.On Sat, Dec 22, 2001 at 04:57:29AM -0600, Raymond Norton wrote:

Yep, I did that. Could it be something happened with the dump? I will try to
do a new one. I followed the previous instructions of dropping the rt2 db,
recreating rt2, then doing a mysql -u -p rt2 < rt2.sqlschema

Am I missing something?

----- Original Message -----
From: “Jesse Vincent” jesse@bestpractical.com
To: “Raymond Norton” ray@lctn.k12.mn.us
Cc: rt-users@lists.fsck.com
Sent: Saturday, December 22, 2001 12:54 AM
Subject: Re: [rt-users] rt2.ACL does not exist

you need to make sure you import the schema before you import the dump.
(or you can do a full dump of them both together)

On Fri, Dec 21, 2001 at 07:36:28PM -0600, Raymond Norton wrote:

I have done a search and cannot find this posted before
I have done a new RT install and want to import rt2 database from
another

server. I have used mysqladmin to remove the rt2 database from the new
server (which was blank)

. I am doing a mysql -u root -pxx rt2 < rt2.sqlschema and rt2.sqldump.
I
get

ERROR 1146 at line 11: Table ‘rt2.ACL’ doesn’t exist.

Any ideas?

Raymond


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.