PROBLEM
My MailRelay table is out of sync.
ENVIRONMENT
- On-Premise Server + WebMail Installations: Version 6.0 > Current Version
CAUSE
If your slave MySQL is out of sync with your primary MySQL, please do the following via MySQL command prompt.
RESOLUTION
drop table MailRelay;
CREATE TABLE `MailRelay` (
`IPaddress` varchar(16) NOT NULL default '',
`DateAdded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Account` varchar(128) default NULL,
`id` bigint(20) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`),
KEY `DateAdded` (`DateAdded`),
KEY `IPaddress` (`IPaddress`),
KEY `Account` (`Account`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Comments