Building a Retrosheet Database for the 2016 Season, Part 1 by David G. Temple March 7, 2016 Baseball season is almost upon us. Soon, people will flood to ballparks in cities all over our great nation in search of entertainment and meaning, while baseball bloggers will continue their search for relevance and the mysterious Full Time Gig. If you fall into the latter camp (or if you just like having this kind of data handy), then it’s time to get your Retrosheet database installed/updated. For those not in the know, Retrosheet is a magnificent project that essentially looks to turn box scores into computer records. And they’ve done a great job of it. They have all box scores from games since 1914, and play-by-play data since around 1940. What we’ll want to do is convert their records into an easily-searchable database that we can query for fun and profit. Below is a video walking you through how to get your machine set up. We won’t actually be loading the data yet — that will come in Part 2 — but we’ll make sure your computer is prepped and has all the files and utilities is needs. If you already installed a Retrosheet database using our instructions from last year, most of this won’t apply to you, but feel free to follow along. You’ll certainly need the links to the new packages that are now up on our GitHub page, but most of what you’ll need is in Part 2. (Mac people: as I mentioned in the video, your instructions are coming) Links mentioned in the video: TechGraphs GitHub: https://github.com/techgraphs/2016Ret… MySQL Server: https://dev.mysql.com/downloads/mysql/ Wget: http://gnuwin32.sourceforge.net/packa… 7-Zip: http://www.7-zip.org/ SQLyog: https://github.com/webyog/sqlyog-comm… We hoped you liked reading Building a Retrosheet Database for the 2016 Season, Part 1 by David G. Temple! Please support FanGraphs by becoming a member. We publish thousands of articles a year, host multiple podcasts, and have an ever growing database of baseball stats. FanGraphs does not have a paywall. With your membership, we can continue to offer the content you've come to rely on and add to our unique baseball coverage. Support FanGraphs