Posted on Aug 07th, 2006

If you're new here, you may want to subscribe to my RSS feed, follow me on Twitter or sign up to my email list.

If you want to talk about how I can help with your social & viral marketing campaigns, contact me. Thanks!

For a corpa to use for an as-yet-unnamed project I’m working on, I’ve been struggling with the unwieldy wikipedia XML dump.

1.4gb of pure XML wikicontent. A huge pain to import however, since SQL dumps are no longer directly released. I had to install mediawiki’s (the software that wikipedia runs on) database structure (in the source code its in maintentance/tables.sql), then run a java program called mwdumper to create an enourmous SQL file. All of that didn’t take very long, what’s taking a while now is actually importing that SQL file.

Contact me to talk about what I can do to help your viral & social marketing campaigns, and don't forget to subscribe to my feed, join my email list or follow me on Twitter to stay up to date.