January 18, 2011

 new MailRelay table for mysql replication

If your slave MySQL is out of sync with your primary MySQL, please do the following via MySQL command prompt.

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;


Filed under: Uncategorized — Stewart Bazley @ 2:49 pm

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment