Re: [dspam-users] migrating from hash to MySQL?
Original-Nachricht > Datum: Thu, 8 Jan 2009 00:37:14 -0500 (EST) > Von: "Simon St.Laurent" > An: dspam-users@lists.nuclearelephant.com > Betreff: [dspam-users] migrating from hash to MySQL? > I'd like to move my DSPAM data from the hash driver to MySQL. There's a > note in the configuration file that I should migrate the data. > > However, my searches for information on how to do that have been > fruitless. I'd definitely prefer not to toss my existing data. > > Are there scripts? Ideas? > It would be possible to take the data from the hash driver and migrate to MySQL. But you will face problems with the currently available tools in DSPAM. The one problem is that the tools for the hash driver are not very rock solid and the second problem is that people use the hash driver when using the Sparse Binary Polynomial Hashing tokenizer. The token data from the hash driver could be migrated to MySQL but you will have a hard time to continue using those tokens (when using SBPH) with the MySQL driver since you will probably change the tokenizer when switching to MySQL. I am pretty sure you will change the tokenizer. Using SBPH with MySQL will be almost not possible since SBPH creates so much tokens that your MySQL installation will suffer from so much tokens. To make the story short: Start with fresh data when switching from hash to MySQL. > -- > Simon St.Laurent > http://simonstl.com > Steve > > !DSPAM:1011,4967547d150921435512920!
Re: [dspam-users] migrating from hash to MySQL?
Thanks! Hopefully this conversation will make it easier for folks to find it in Google in the future... Alas, it gives me a 0-length file run without sudo, and a segmentation fault right away when run with sudo. Hrmph. The data came from another (dying) server, so maybe it's just broken. Thanks, Simon St.Laurent - "Kyle Johnson" wrote: > On Thu, Jan 8, 2009 at 12:37 AM, Simon St.Laurent > wrote: > > > I'd like to move my DSPAM data from the hash driver to MySQL. > There's a > > note in the configuration file that I should migrate the data. > > > > However, my searches for information on how to do that have been > fruitless. > > I'd definitely prefer not to toss my existing data. > > > > Are there scripts? Ideas? > > > > -- > > Simon St.Laurent > > http://simonstl.com > > > > > > > I think what you are looking for can be done with the dspam_2sql > tool. > > -Kyle -- Simon St.Laurent Editor, O'Reilly Media, Inc. !DSPAM:1011,49660eaa150927998615219!
Re: [dspam-users] migrating from hash to MySQL?
On Thu, Jan 8, 2009 at 12:37 AM, Simon St.Laurent wrote: > I'd like to move my DSPAM data from the hash driver to MySQL. There's a > note in the configuration file that I should migrate the data. > > However, my searches for information on how to do that have been fruitless. > I'd definitely prefer not to toss my existing data. > > Are there scripts? Ideas? > > -- > Simon St.Laurent > http://simonstl.com > > I think what you are looking for can be done with the dspam_2sql tool. -Kyle !DSPAM:1011,496592c1150921342664970!
[dspam-users] migrating from hash to MySQL?
I'd like to move my DSPAM data from the hash driver to MySQL. There's a note in the configuration file that I should migrate the data. However, my searches for information on how to do that have been fruitless. I'd definitely prefer not to toss my existing data. Are there scripts? Ideas? -- Simon St.Laurent http://simonstl.com !DSPAM:1011,4965910b150921355547334!
