open All Channels
seplocked EVE Technology Lab
blankseplocked Incarna 1.0 static data dump MySQL dump, ready! (First version)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Daid Thiefsant
Posted - 2011.07.06 12:04:00 - [1]
 

Edited by: Daid Thiefsant on 07/07/2011 08:43:07
Edited by: Daid Thiefsant on 06/07/2011 12:59:12
Edited by: Daid Thiefsant on 06/07/2011 12:55:24
Edited by: Daid Thiefsant on 06/07/2011 12:30:27
Edited by: Daid Thiefsant on 06/07/2011 12:13:06
Edited by: Daid Thiefsant on 06/07/2011 12:04:00
I've made an MySQL dump from the Incarna static dump. This is my first conversion so there might be problems.

I've not converted the following tables yet:
eveLocations - Huge table of Name<->Location. While interresting, this table is 1GB in the MSSQL dump. I'll be providing this later as seperate download.
invItems - Same eve eveLocations. This table is huge, however, it's also NEW!
mapCelestialStatistics - Just lore information and a huge table.
eveOwners - My export from the MSSQL table is broken in the date/time fields. So I'll need to look at this.
(These tables are missing from the dump, so not even the table information is included, no empty tables)

SQL dump can be found at: (Look a few posts down)

I'll be looking at the differences between the 1.5 Incursion and 1.0 Incarna data later on.

If you use this dump, please consider sending me some ISK. I could really use it as a starting player.



NOTE: If you use this, I just noticed a few indexes are missing. So if your queries are slow, check if the fields you are selecting on have indexes! Also, the translations table doesn't contain the Russian characters.

Fuegas Mani
Posted - 2011.07.06 12:42:00 - [2]
 

Edited by: Fuegas Mani on 06/07/2011 12:45:32
My bad, ignore this post space ;)

Pyro Mani
Posted - 2011.07.06 12:44:00 - [3]
 

Edited by: Pyro Mani on 12/07/2011 00:21:26
Hosted again on 100Mbit: (updated version)

Incarna 1.0 MySQL dump by Daid Thiefsant 25MB (Missing tables: "invItems", "mapCelestrialStatistics", "eveLocations". These tables are each larger then the 'base' data, and are seperate downloads, "eveOwners" didn't export right from mssql)
Incarna 1.0 MySQL dump by Daid Thiefsant 106MB (Only the evevLocation table)
Incarna 1.0 MySQL dump by Daid Thiefsant 40MB (Only the invItems table)
Incarna 1.0 MySQL dump by Daid Thiefsant 22MB (Only the mapCelestrialStatistics table)

Daid Thiefsant
Posted - 2011.07.07 08:42:00 - [4]
 

I've fixed the indexes, and the export of the translation table. I also finally converted the 3 missing tables.

Incarna 1.0 MySQL dump by Daid Thiefsant 25MB (Missing tables: "invItems", "mapCelestrialStatistics", "eveLocations". These tables are each larger then the 'base' data, and are seperate downloads, "eveOwners" didn't export right from mssql)
Incarna 1.0 MySQL dump by Daid Thiefsant 106MB (Only the evevLocation table)
Incarna 1.0 MySQL dump by Daid Thiefsant 40MB (Only the invItems table)
Incarna 1.0 MySQL dump by Daid Thiefsant 22MB (Only the mapCelestrialStatistics table)

Lupus Hekki
Caldari
Legio Carminatus
Posted - 2011.07.07 09:50:00 - [5]
 

Edited by: Lupus Hekki on 08/07/2011 13:38:33
Edited by: Lupus Hekki on 08/07/2011 13:38:10
Edited by: Lupus Hekki on 08/07/2011 13:36:36
Edited by: Lupus Hekki on 08/07/2011 10:27:18
Edited by: Lupus Hekki on 08/07/2011 10:24:12
These are DATA changes, alot of tables have changed tinyints to smallints, as this could either be CCP preparing for a new load of data, or the converter isn't state of the art

Changes for agtAgents
divisionID is now somewhat higher (10?) probably because of the new agent categories
quality is now overall 0 ( wtf? this could be a problem in the conversion, i can see some tools breaking )

agtConfig
v is overall 0 or 1 ( i can see some tools breaking )

invItems
This looks like a dynamic table Shocked (most probably not got deleted in the static export? or this contains NPC items, one of the two)

eveOwners
Sovt info (on empires' corps?)

eveLocations
This looks like something a 3D map could use, contains 3D vectors of all EVE solarsystems/regions/constellations and some other weird stuff? ("[EVE DELETED ITEMS]")

Reupload.
Incarna10.sql
Incarna10eveLoc.sql
Incarna10invItems.sql
Incarna10mapCelStat.sql
Incarna10eveOwners.sql - waiting for daid
Incarna10full.sql - waiting for eveOwners
Incursion14agtAgents.sql (use this if your app/program uses agtAgents)
Incursion14agtConfig.sql (use this if your app/program uses agtConfig)
--------
Full database freshly exported (Table by table, by me, credit still goes to Daid for forcing me to do it because i want eveOwners)

I have wasted too much time on this, thats for sure Rolling Eyes
Well, back to making my own killboard

Daid Thiefsant
Posted - 2011.07.07 18:10:00 - [6]
 

I changed the tinyint to smallint. Tinyint in SQL server goes from 0 to 255, while in MySQL it goes from -128 to 127. I was getting primary key conflicts in 1 of the tables because of this.

I switched my own site (internal corp use only) from the Incursion 1.5 dump to the Incarna 1.0 dump I made myself without any issues.

I'll have a look at the agtAgent table to see if that's a conversion error on the 'quality' field. But this looks the same as in my Incursion 1.5 database. Same for the 'v' field in 'agtConfig'.

Lupus Hekki
Caldari
Legio Carminatus
Posted - 2011.07.08 10:15:00 - [7]
 

Edited by: Lupus Hekki on 08/07/2011 10:31:53
Originally by: Daid Thiefsant
I changed the tinyint to smallint. Tinyint in SQL server goes from 0 to 255, while in MySQL it goes from -128 to 127. I was getting primary key conflicts in 1 of the tables because of this.

I switched my own site (internal corp use only) from the Incursion 1.5 dump to the Incarna 1.0 dump I made myself without any issues.

I'll have a look at the agtAgent table to see if that's a conversion error on the 'quality' field. But this looks the same as in my Incursion 1.5 database. Same for the 'v' field in 'agtConfig'.

Probably your corp site doesn't use the agent tables
I meant tools like agent finders.

Pyro Mani
Posted - 2011.07.12 00:21:00 - [8]
 

Hosted again on 100Mbit:

Incarna 1.0 MySQL dump by Daid Thiefsant 25MB (Missing tables: "invItems", "mapCelestrialStatistics", "eveLocations". These tables are each larger then the 'base' data, and are seperate downloads, "eveOwners" didn't export right from mssql)
Incarna 1.0 MySQL dump by Daid Thiefsant 106MB (Only the evevLocation table)
Incarna 1.0 MySQL dump by Daid Thiefsant 40MB (Only the invItems table)
Incarna 1.0 MySQL dump by Daid Thiefsant 22MB (Only the mapCelestrialStatistics table)


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only