Can I backup and restore only the bayes database with the same procedure? Thanks,
rocsca ----- Original Message ----- From: "Pete Barnwell" <[EMAIL PROTECTED]> To: "Rocco Scappatura" <[EMAIL PROTECTED]> Sent: Monday, December 19, 2005 1:05 PM Subject: Re: [AMaViS-user] Bayes database > > > On Mon, 2005-12-19 at 12:40 +0100, Rocco Scappatura wrote: > > 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... > > Hi, > > With minimal downtime:- > > stop SQL on the master server. > > tar cvf /var/lib/mysql mysql.tar > > start SQL on the master. > > scp the tar file over to the slave. Stop the slave, untar the file > > In /var/lib/mysql on the slave, delete files:- > > master.info > <hostname-of-master>-bin.* > > Then start slave and all should be well. > > You may have to adjust the path I gave above - they're correct for RH. > > Cheers > > Pete > > > > 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/ ------------------------------------------------------- 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/
