EVE Search - SDE and IEC for Crucible 1.1

All Channels

EVE Technology Lab

SDE and IEC for Crucible 1.1

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] 2 :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
Desmont McCallock 100	Posted - 2012.01.24 17:38:00 - [1] - Quote Static Data Export IEC Types IEC Renders IEC Icons Change Log: -- CHANGED IN CRUCIBLE 1.1 -- Removed table agtConfig, all info should be available in agtAgents -- Removed table translationLaguages, it should never have existed. Proper name is trnTranslationLanguages. -- Removed column sceneID from mapLocationScenes and replaced it with graphicID representing the nebula graphic. P.S: I would like to apologize to CCP Stillman for stealing his work. P.S: DB conversions will follow soonGäó.
Kaladr Dreddit Test Alliance Please Ignore 20	Posted - 2012.01.24 18:42:00 - [2] - Quote Excellent. Now if the dumps didn't actually require MSSQL /awaits SQLite conversion Creator of EVE-Central.com, the longest running EVE Market Aggregator
Artctura Clan Shadow Wolf Fatal Ascension 9	Posted - 2012.01.24 19:02:00 - [3] - Quote Swap stickies with the 1.0 post. And yes, awaiting mysql conversion.
Zagdul Clan Shadow Wolf Fatal Ascension 355	Posted - 2012.01.24 19:33:00 - [4] - Quote CCP: Please convert these to MYSQL / SQLite for us Thanks! It's not Rocket Surgery
6ie State War Academy Caldari State 0	Posted - 2012.01.24 20:01:00 - [5] - Quote Thank you very much! MYSQL Dump imported without error. I 'Liked'!
D Program Ambient Fleet 7	Posted - 2012.01.24 21:08:00 - [6] - Quote Yes yes, thank you! What is this sorcery? http://www.starcraft.ee/eve/
Matalok Dreddit Test Alliance Please Ignore 13	Posted - 2012.01.25 19:11:00 - [7] - Quote Thank you for saving me from the horrors of MSSQL db conversion.
Louis Vitton Invictus Australis Northern Coalition. 13	Posted - 2012.01.25 20:44:00 - [8] - Quote Thank you :)
Drapko Nitzhonot Abdera Logistics 2	Posted - 2012.01.26 04:05:00 - [9] - Quote Thank you for MySQL!!!
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 75	Posted - 2012.01.26 19:51:00 - [10] - Quote MySQL with capitalization would be very nice as well... but thanks anyway! Developer/Creator of EVE Marketeer
Desmont McCallock 112	Posted - 2012.01.26 19:57:00 - [11] - Quote I'm under the impression that "all lower" is MySQL standard. Have I missed something?
Ramov Tinoga Tinoga Enterprises 0	Posted - 2012.01.27 09:15:00 - [12] - Quote It depends.. For InnoDB probably yes. Previous conversions (with the tables using MyISAM if I'm not mistaken) offered mixed capitalization which was useful for easier reading on my Linux MySQL, but I make my scripts non-portable when I use it like that. Many thanks for the conversion! Callean Drevus wrote: MySQL with capitalization would be very nice as well... but thanks anyway! If you want the old table name capitalization back, you can use this script: http://pastebin.com/0jwhPfNm NOTE: This is only useful for DB admins that have their mysql database on case sensitive file systems on LInux or UNIX.
Desmont McCallock 113	Posted - 2012.01.27 09:31:00 - [13] - Quote Last conversion provided by Jercy Fravowitz (incarna 1.4), which was using MyISAM engine, had no capitalization. So I tried to keep some compatibility on that. As for the engine selection, asking around people that know more than me about MySQL and doing some search on the web, I was convinced that InnoDB is preferred, and should be used, over MyISAM.
Luminocity Filthy Thirteen 2	Posted - 2012.01.27 13:51:00 - [14] - Quote Here's another MySQL 5 export with camelCase table name capitalization, no extended inserts and MyISAM engine like the one's I've made before: crucible1.1.334471-mysql5-v1.zip Enjoy!
Aineko Macx Royal Amarr Institute Amarr Empire 126	Posted - 2012.01.27 15:09:00 - [15] - Quote The (non) capitalization is related to the case sensitiveness of the underlying file system. The windows FSs are not, therefore MySQL under Windows is table case insensitive as well and it defaults to lower case. As for MyISAM and InnoDB, since this is a static data set, there is limited benefit from using InnoDB for these tables. Your application tables can ofc still use InnoDB and benefit from transactions, foreign keys (they can point to MyISAM tables), etc. Tho having the FKs in the SDE helps in understanding the DB schema
Desmont McCallock 115	Posted - 2012.01.27 15:28:00 - [16] - Quote Aineko Macx wrote: ...benefit from transactions, foreign keys (they can point to MyISAM tables), etc. Exactly the reason for choosing InnoDB as engine of my MySQL conversions. Thanks, Aineko (here catch a "Like").
Jercy Fravowitz School of Applied Knowledge Caldari State 1	Posted - 2012.01.27 20:51:00 - [17] - Quote Desmont McCallock wrote: Last conversion provided by Jercy Fravowitz (incarna 1.4), which was using MyISAM engine, had no capitalization. cough i am not even sure where to start there... a) Incarna 1.4? unless i missed something, there was no Incarna 1.4 dump. there was, however, Incursion 1.4 ... b) just because i dont post them doesnt mean they dont exist. Ruziel posted links to my inca10, and according to my traffic stats enough people found inca11, cru10b and cru110 ... c) no, i do not change the capitalization provided by ccp. if they call it invTypes, i will keep the capital T. assuming you meant Incursion 1.4 in your allegation, take a close look at the inc14-mysql-schema ... d) for the "myisam vs innodb", i am going with a pragmatic solution that "should work for most people reasonably well". the main dump is myisam with no-autocommit and no-extended-inserts. myisam is what most people want anyways (i tend to run myisampack on mine), the no-ext-ins means it will work in weird webloader-scripts, and the no-ac means it will be less slow. for the innodb users, there is update-innodb.sql which converts the tables to innodb one by one, and adds FKs. this approach has been about 1.5 orders of magnitude faster than trying to load with no-ext-ins-but-ac into innodb directly. e) while i am attentionwhoring here, could those of you who know what invTypes is without having to ask google and are going to attend fanfest please briefly pay attention to this and post if interested in the drinking part?
Desmont McCallock 115	Posted - 2012.01.28 10:20:00 - [18] - Quote 1. Yes the correct reference is Incursion 1.4 and not Incarna (my bad). 2. As I have mentioned I'm fairly new in the DB conversion business and the only reason I got involved is because you (Jercy) stopped posting the links (and driving some users mad). Now that I know that you keep doing them, I'll do a better search (or guessing) of where you have the files in your server and will stop doing them myself. So people no more DB conversions from me but I'll keep trying to provide the links from Jercy's DB conversions, if noone else does.
Drapko Nitzhonot Abdera Logistics 3	Posted - 2012.01.28 12:03:00 - [19] - Quote Desmont McCallock wrote: 2. As I have mentioned I'm fairly new in the DB conversion business and the only reason I got involved is because you (Jercy) stopped posting the links (and driving some users mad). Now that I know that you keep doing them, I'll do a better search (or guessing) of where you have the files in your server and will stop doing them myself. So people no more DB conversions from me but I'll keep trying to provide the links from Jercy's DB conversions, if noone else does. I prefer "clear" (not hidden, with date and time build) dumps. Please Desmont, don't stop doing them!
6ie The Kiwis 1	Posted - 2012.01.28 12:28:00 - [20] - Quote Thank you guys for doing these now and in the past. The MySQL conversions work brilliantly and without them I would not be able to make ~1billion ISK per day. (I wish).
Aineko Macx Royal Amarr Institute Amarr Empire 137	Posted - 2012.02.08 18:57:00 - [21] - Quote I noticed none of the MySQL InnoDB dumps contain foreign keys, so I made a script that adds them. I took Jercy's MyISAM dump as base. It should also work with Luminocity's if you skip the first batch of statements that convert to the InnoDB engine. Desmont's dump is missing all indexes except primaries. http://pastebin.com/5dS84J8X Note the script is quite I/O intensive and runs for a while.
Cyerus Galactic Dominion Eternal Strife 16	Posted - 2012.02.08 20:25:00 - [22] - Quote Voted for sticky (as usual with database dump!). Thanks again guys
morrosis Black Shadows. Army of Dark Shadows 0	Posted - 2012.02.08 21:34:00 - [23] - Quote Thank downloading now.
Aineko Macx Royal Amarr Institute Amarr Empire 137	Posted - 2012.02.09 06:35:00 - [24] - Quote You are probably trying to import via phpMyAdmin, which is contrained by upload size limits and whatnot. I normally import dumps via the mysql command line client. Should be included in xampp under xampp\mysql\bin. Usage: mysql -u dbusername -p dbname < dump.sql
Moebius27 Deep Core Mining Inc. Caldari State 0	Posted - 2012.03.07 21:01:00 - [25] - Quote Aineko Macx wrote: Usage: mysql -u dbusername -p dbname < dump.sql this is definitly the best way to import massive data.
6ie The Kiwis 3	Posted - 2012.03.14 19:24:00 - [26] - Quote Paying top dollar for a MYSQL conversion of the latest dump http://content.eveonline.com/data/Crucible_1.5_349247_db.zip
Desmont McCallock 135	Posted - 2012.03.14 19:38:00 - [27] - Quote Unfortunately this time you all will have to wait for Jercy's Fravowitz versions. I'm done with DB conversions.
Steve Ronuken Fuzzwork Enterprises 299	Posted - 2012.03.15 00:30:00 - [28] - Quote 6ie wrote: Paying top dollar for a MYSQL conversion of the latest dump http://content.eveonline.com/data/Crucible_1.5_349247_db.zip Challenge Accepted https://forums.eveonline.com/default.aspx?g=posts&t=81559 FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator and other 'useful' utilities.
Magnifikus Erzverwirrer Endstati0n Raiden. 15	Posted - 2012.04.30 22:04:00 - [29] - Quote any plans on the escalation db? if not can you give me the method/tools to do it :)
Steve Ronuken Fuzzwork Enterprises 391	Posted - 2012.04.30 22:09:00 - [30] - Quote Magnifikus Erzverwirrer wrote: any plans on the escalation db? if not can you give me the method/tools to do it :) https://forums.eveonline.com/default.aspx?g=posts&t=100797 FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.

Pages: [1] 2 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.