CCP Database Dump Resources
From EVEDev
Contents |
[edit] About The Database Dump
Can we get something in here...some background, what it includes, rather than assumed knowledge?
[edit] Database dump info
[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.
[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
[edit] Older Dumps
[edit] MS Access 2000 Dumps
[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,...)

