Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 153 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Has anyone got any tools/scripts etc. for getting the data dump into MySQL?

share|improve this question
2  
I have one :( But I'm not sure if I want to release my ugly code. – Ian Elliott Aug 13 '09 at 16:41
up vote 4 down vote accepted

I've got a script and schema for mysql that you can use if you are interested. The load script requires Ruby. I also split a tags out into their own table.

share|improve this answer
    
I was wondering this is up to date with the latest data dump? – find-missing-semicolon Apr 17 '12 at 15:47
    
will this work for stackexchange dataset? Thank You. – find-missing-semicolon Nov 6 '12 at 22:40
    
I know I have used your script in past but don't recall of this error: but I just recently tried and I am getting an error in badges.xml at <row Id="253861" UserId="74951" Name="Autobiographer" Date="2009-03-08T02:02:32.390" /> : Incorrect datetime value: '2009-03-08T02:02:32.390' for column 'created' at row 1 (Mysql::Error) – find-missing-semicolon Feb 8 '14 at 19:14

The following is a project that can import all of the latest dumps (as of August 2014) into any relational database that supports JPA/hibernate. It is written in Java, but can also be used from the command line. Prerequisites are Java 8 and Maven.

https://github.com/1123/StackExchangeImporter

share|improve this answer

See also this (duplicate) answer asked yesterday.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .