Other then query the MySQL grant table I am not sure of a good way to reconcile recent changes. As for out of sync replication stop the replication, apply a backup, start replicaiton.
Sorry I don't have better advice. I can try playing around with some stuff this weekend and would love to know your solution if you find one before then. On Thu, Jul 22, 2010 at 11:00 PM, der.hans <pl...@lufthans.com> wrote: > moin moin, > > is there a way see when a particular grant was last used in MySQL? I can > probably troll logs, but I wonder if it's in the DB. > > Also, how should I sync grants from master to slave when they're out of > sync? > > In our case, the slave is also getting local changes. I'm pushing to stop > that, but haven't yet gotten it worked out. The local changes to the slave > didn't drop the missing grants, but since we've had emergency repairs > after local changes caused problems, it might be that the repairs did > cause the differences. > > ciao, > > der.hans > -- > # http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/ > # Director of Engineering, FonWallet Transaction Solutions, Inc. > # "The reasons for my decision to quit were myriad, but central to the > # decision was the realization that there are two kinds of companies: > # Good ones ask you to think for them. > # The others tell you to think like them." -- Benjy Feen > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss