I use currently Vim to read SO's data dump. However, my Macbook slows down when I roll down just a few rows. This suggests me that there must be more efficient ways to read the data.
I know little MySQL. The files are in .xml -format. It is rather hard to read the data at the moment in .xml. It may be more efficient to convert the xml -files to MySQL and then read the files. I know only MS db -tool for such actions. However, I would like to know another tool too.
Problems
- to parse .xml to SQL -queries such that MySQL understand it. We need to know data structures of the data.
- to run the data in MySQL
- to find some tool similar to MS db -tool by which we can read the data effectively
How do you read SO's data dump effectively?
--
[edit]
- How can you run the 523 SQL queries to create the database in your terminal? I have the commands at the moment in a text -file.
- How can you "switch to [the recovery mode] to a simple recovery mode in the database?
I made my first ever python program to read them and output SQL insert statements for use with mysql (It's ugly but worked). You'll need to create the tables first though by hand.