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.