some things are worth being preserved and one of them are the newsgroups. so as a little weekend project i put all sgi related newsgroups except for marketplace into mysql. cut off date is somewhere in 2006. the fields are:
all fields are indexed (msg as fulltext) and all rows have the usual autoincrement id as primary key.
the dates are converted to proper sql dates and to the actual content i applied the following changes:
if that sounds handy to you you're welcome to download the sql dumps there:
- from
- subject
- date
- msg
all fields are indexed (msg as fulltext) and all rows have the usual autoincrement id as primary key.
the dates are converted to proper sql dates and to the actual content i applied the following changes:
- trailing blanks removed
- number of consecutive blank lines limited to 2
- quoted-printable content converted
- empty mails skipped
- subjects are cut off by "..." if they exceed 128 chars
if that sounds handy to you you're welcome to download the sql dumps there:
Code: Select all
http://r-a-c.de/sgi/comp_graphics_apps_alias.sql.xz
http://r-a-c.de/sgi/comp_graphics_apps_wavefront.sql.xz
http://r-a-c.de/sgi/comp_graphics_packages_alias.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_admin.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_announce.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_apps.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_bugs.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_graphics.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_hardware.sql.xz
http://r-a-c.de/sgi/comp_sys_sgi_misc.sql.xz
r-a-c.de
