Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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 06/07/2011 12:45:07 Mirrored at: http://vuurtje.kassala.de/eve/Incarna10.sql.bz2 (100 Mbit, no cap)
|
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
|
Posted - 2011.07.07 09:50:00 -
[5]
Edited by: Lupus Hekki on 07/07/2011 09:53:14 Edited by: Lupus Hekki on 07/07/2011 09:52:03 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 Placeholder
eveOwners Placeholder
eveLocations Placeholder
Daid, get a better server, 1 hour for a 102mb file, geez, will reupload.
|
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
|
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)
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |