11

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

  • 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

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.

  • I was wondering this is up to date with the latest data dump? – add-semi-colons Apr 17 '12 at 15:47
  • will this work for stackexchange dataset? Thank You. – add-semi-colons 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) – add-semi-colons Feb 8 '14 at 19:14
1

Here is a windows app that will import to MySql,MS Sql and SQLite:

https://meta.stackexchange.com/questions/45333/fast-multi-platform-data-dump-import-sql-2000-05-08-sqlite-mysql

0

See also this (duplicate) answer asked yesterday.

0

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

You must log in to answer this question.

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