6

I downloaded the Stack Overflow data dump for the last month. It has six files, with names like stackoverflow.com.7z.001, stackoverflow.com.7z.002, etc. I tried to open one of them with Notepad++, it showed a pile of binary data, suggesting that it might be a dump. Now, how do I import it into MySQL?

Is the dump already in format Insert into table values (), or is it just the data in some space separated or CSV format, that has to be loaded? Plus any idea about the table schemas? The Meta Stack Overflow post Database schema documentation for the public data dump and Data Explorer gives you an idea about the nature of the data the tables contain, but it doesn't tell you about the schema.

4

1 Answer 1

9

The post you link to, Database schema documentation for the public data dump and SEDE, is the schema; so yes it does contain the schema. You can get column sizes from the Data Explorer if you want.

You might find Scripts to convert data-dump to other formats helpful.

The fact that the files are .001, .002, etc. would imply that it's been split. Probably using 7-Zip's split functionality. You can either use 7-Zip to recombine them or use another tool such as HJSplit.

4
  • By schema I meant the table structure, structure of the columns. This post only describes what each column represents, for example, name of the voter, his id, etc, whereas I want to know whether that column is of type char(50) or varchar(100). Sep 1, 2012 at 8:32
  • 1
    @Cupidvogel Ben already answered this, you can get the column types & sizes from Data Explorer.
    – yannis
    Sep 1, 2012 at 8:43
  • Thanks, the scripts are very helpful. I'm able to convert them to SQL Server scripts. Jul 26, 2019 at 23:51
  • @NicholasHumphrey can you share your SQL Server scripts? Sep 15, 2023 at 17:56

You must log in to answer this question.

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