What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 128 Stack Exchange communities.

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

4 Answers 4

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 at 19:14

See also this (duplicate) answer asked yesterday.

share|improve this answer

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

You must log in to answer this question.

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