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
add comment

3 Answers

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
add comment

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

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

share|improve this answer
add comment

See also this (duplicate) answer asked yesterday.

share|improve this answer
add comment

You must log in to answer this question.

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