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=click _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/