Fw: [rt-users] rt2.ACL does not exist

[Jesse Vincent]

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 at bestpractical.com>
> > To: "Raymond Norton" <ray at lctn.k12.mn.us>
> > Cc: <rt-users at 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 at 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 at lists.fsck.com
> > > http://lists.fsck.com/mailman/listinfo/rt-users
> > >
> >
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

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