Swap Disk Database Dump
Message #1 Posted by Howard Owen on 23 Nov 2005, 4:39 p.m.
I've been using a SQL table I made of the contents of the swap disks for some time. I just answered a question using the database, and it occurred to me that others might appreciate having access to it. The swap disk images are available from the Museum site here. My database dump is here. It's in phpMyAdmin dump format, which is basically a set of SQL statements to create the table in an existing MySQL database. It should be readily adaptable to other database types with a little Perl code, or even just hand editing.
Here's a typical query I run against this table. (This is in fact the one I used to answer the recent question.)
SELECT * FROM FILES WHERE TYPE LIKE '%71" AND NAME LIKE 'MATH%';
This told me that the 71B math rom in a lex file was on the ATCHO swap disk, in the file called "MATHROM'.
Regards,
Howard
| 
Go back to the main exhibit hall