CCP Database Dump Resources

From EVEDev

Contents 1 About The Database Dump 1.1 Database dump info 1.2 Requests 1.3 Small tables not included in dump 1.4 Database in action 2 Files 2.1 Images & Icons 2.2 MS SQL Dump 2.3 Conversions 3 Older Dumps 3.1 MS Access 2000 Dumps 3.2 CSV(Text)Dumps 4 Links

[edit] About The Database Dump

Can we get something in here...some background, what it includes, rather than assumed knowledge?

[edit] Database dump info

• SQL Methods on the dump
• Database Tables Explained

[edit] Requests

Please put requests in Database Dump Requests.

[edit] Small tables not included in dump

• Minerals distribution per solar systems
• Minerals distribution per solar system security class
• Ore reprocessing results
• NPC faction / corporation graphic mappings
• Ice lookup table

[edit] Database in action

• We included the whole database into the wiki, for details on how to use it see Help:Editing

[edit] Files

[edit] Images & Icons

• http://ccp.vo.llnwd.net/o2/data/EmpyreanAge_1.0_img_icons.zip - includes alliance logos
• http://ccp.vo.llnwd.net/o2/data/EmpyreanAge_1.0_img_types_dx8.zip
• http://ccp.vo.llnwd.net/o2/data/EmpyreanAge_1.0_img_types_dx9.zip
  • http://ccp.vo.llnwd.net/o2/data/EmpyreanAge_1.0_img_blueprints.zip - this is contained in types_dx9

[edit] MS SQL Dump

This is the official version generated by CCP (forum post). It is an MSSQL .bak file, which will need to be imported whole before you can do anything with it.

• http://ccp.vo.llnwd.net/o2/data/QuantumRise_1.0.0.69477_db.zip
• IconToAllianceID Mappings

[edit] Conversions

too much work to update the full list here each time, so just link to the jump page. Covered are: MSSQL, MySQL, SQLITE, postgres, XML

• QR100 readme page with explanations
• QR100 raw dir index

[edit] Older Dumps

[edit] MS Access 2000 Dumps

• http://vwgn.com/eve/EmpAgeDB/eveEmpyreanAgeDBExport_1.0_Access2000.rar

[edit] CSV(Text)Dumps

• http://vwgn.com/eve/EmpAgeDB/eveEmpyreanAgeDBExport_v.10_CSV.rar > the zealot record in this file appears to have some extra text at the end. the onyx record is missing, so I'm guessing it got mangled somehow. This makes the entire conversion suspect.
  • there are way too many flavors of "CSV Format", but if you visit #eve-dev on irc.coldfront.net and ask for something specific like "i need tables x, y and z, using comma as field separator, doubletick to quote fields, backslash to escape" you will probably get what you are looking for quickly. -- Zofu 15:41, 27 September 2008 (UTC)

[edit] Links

• EA Export blog by Prism X
• E-O Community Toolkit
• Database Dumps by Chruker (MySQL, Table relations,...)