The SSL Observatory is a great project from the EFF to gather all SSL certificates available on HTTPS websites and publish them for analysis. For more details see the SSL Observatory website.

The main problem if you don’t want to analyse it using their pre-configured Amazon EC2 configuration is that the compressed .sql file is around 3 Go compressed using LZMA and 3 To uncompressed so you can’t even un-compress the file and need to pipe directly from 7-Zip to mysql.

To do it either on windows or linux :

7z e -so "observatory-dec-2010.sql.lzma" f | mysql -u root --password=toto42sh observatory2

Note: The 7z tools is in the p7zip package on a debian system.