hello, I agree your point of view... But I have one db (master) with a second (slave) whose is a replica of the first.. It's happened (and I can exclude that it will happen in the future) that I have to align the second data base because slave failed.
With the process above I have to change the SA config on amavisd-new server so that use the slave as database host... and so I have to block service for all the time data are restored... :( Any Idea for a process that prevent this, is appreciate... Thanx, rocsca ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, December 17, 2005 4:33 AM Subject: Re: [AMaViS-user] Bayes database > > Mark Martinec wrote: > > >Rocco, > > > > > > > >>I'm using spamassassin with database MySQL. > >>I have many problem when I try to restore dumped data to another DBMS (for > >>high availability pupouse). > >> > >>Infact, I have often problems like this: > >> > >>mysql2:/home/rocsca/slave # mysql -u root < bayes.sql > >>ERROR 1062 (23000) at line 245: Duplicate entry '4-ÈÜ?' for key 1 > >> > >>Is an encoding problem? Anyone had similar problem? > >> > >> > > > >Corrupted database, needs repair: > > > >$ mysql sa > > REPAIR TABLE bayes_expire, bayes_seen, bayes_token, awl; > > > >It happens from time to time with MyISAM storage engine, > >and it never happened again since I switched Bayes to InnoDB engine > >and started using the new SA 3.1 plugin for MySQL - placing the > >following in local.cf: > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > > > >See file sql/README.bayes in the SA distribution. > > > > Mark > > > > > > > > > For what it's worth, I've never had success dumping bayes tokens from > mysql using mysqldump even on a perfectly repaired database, the tokens > appear to be stored in binary format, but dumps as a string. For > backup purposes, I've resorted to doing an "sa-learn --backup". > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_idv37&alloc_id865&opÌk > _______________________________________________ > AMaViS-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/amavis-user > AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 > AMaViS-HowTos:http://www.amavis.org/howto/ ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
