Posted - 2008.07.15 12:49:00 - [1]

 

Edited by: Vessper on 18/07/2008 17:48:57
Having an urgent need to get hold of the latest export so I can update item, attribute and map data from the last 2 major patches, I decided to bite the bullet and try and recreate an export from the cache files.

I think I have succeeded to an extent and have been using this export for the last couple of days on my own application. I thought someone else may find this useful so I'm making this available for anyone that would like it. Please be aware that this is not a complete export of the EA data, is not supported by CCP and there could well be some discrepancies when compared with the last export. Therefore if you use it, please test it fully with your application/tool/whatever.

Here's a list of the changed tables:

agtAgents
crpNPCCorporations
dgmAttributeTypes
dgmTypeAttributes
dgmTypeEffects
dgmEveNames
invBlueprintTypes
invCategories
invGroups
invMetaGroups
invMetaTypes
invTypes
mapConstellationJumps
mapConstellations
mapDenormalize
mapRegionJumps
mapRegions
mapSolarSystemJumps
mapSolarSystems
staStations
TL2MaterialsForTypeWithActivity

Unfortunately, not all the data is available in the cache files so I've had to take a guess at some of the data for the new systems/NPCCorps. Hopefully it won't be to far out! I've also not bothered to alter the character tables, corporation tables (other than crpNPCCorporations), ram tables and station tables (other than staStations)

Special thanks go to Nightblade (http://myeve.eve-online.com/ingameboard.asp?a=topic&threadID=724413&page=4#105) for his work in converting the bulk of the cache files for this backup.

I hope someone else finds this useful until the official export arrives

Download links:

MYSQL: http://www.evehq.net/data/Empyrean_Age_MySQL_Backup.zip (36Mb)
MSSQL (MDF): http://www.evehq.net/data/Empyrean_Age_MSSQL_Backup.zip (48Mb)
MDB (Access): http://www.evehq.net/data/Empyrean_Age_MDB_Backup.zip (60Mb)
CSV: http://www.evehq.net/data/Empyrean_Age_CSV_Backup.zip (36Mb)