EVE Search - Apocrypha DB Dump Is Out

All Channels

EVE Technology Lab

Apocrypha DB Dump Is Out

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

Monitor this thread via RSS [?]

Pages: [1] 2 3 :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
Verite Rendition Caldari F.R.E.E. Explorer Wildly Inappropriate.	Posted - 2009.03.18 02:48:00 - [1] Edited by: Verite Rendition on 18/03/2009 02:49:45 Word comes from the boys over at the EVE Dev Network that the DB dump is finally out. http://ccp.vo.llnwd.net/o2/data/Apocrypha_1.0.0.84609_db.zip ---- FREE Explorer Lead Megalomanic EVE Null-Sec Player Influence Map http://dl1.eve-files.com/media/corp/Veritefw/FWinf
Dragonaire Caldari Corax.	Posted - 2009.03.18 03:39:00 - [2] Good news hopeful within a couple days we'll see all the conversions also -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
Sidrat Flush Caldari Life is Experience Rally Against Evil	Posted - 2009.03.18 04:12:00 - [3] Is that the right build number? -------------------------- Life is about memories the more the better. Eve Online Batch Calculator
Dragonaire Caldari Corax.	Posted - 2009.03.18 04:18:00 - [4] I not even paying attention to that myself wouldn't be the first time they were different. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
neoe77	Posted - 2009.03.18 04:21:00 - [5] why not update http://www.eveonline.com/community/toolkit.asp ? --------- check path using eve-path-find
Dragonaire Caldari Corax.	Posted - 2009.03.18 04:47:00 - [6] wouldn't be the first time it wasn't update at the same time they released it. It'll probably get updated soon too -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
Ki Tarra Caldari Ki Tech Industries	Posted - 2009.03.18 15:40:00 - [7] Originally by: Sidrat Flush Is that the right build number? AFIAK, that was the interm build number for the version of Apoc included on the retail DVD. It is also the build that the first Apoc patch installed: remember that expansion came in a two part patch. It might not be the final Apoc data dump, so we might still see a newer version.
Ki Tarra Caldari Ki Tech Industries	Posted - 2009.03.18 15:51:00 - [8] *IMPORTANT* Keep a copy of your QR data dump. ALL NPC Attributes have been removed from the Apoc data dump. ---------------------------------- -- REMOVED IN APOCRYPHA ---------------------------------- -- All dgmTypeAttributes records for category = 11 (entities) or group = 988 (wormholes)
Verite Rendition Caldari F.R.E.E. Explorer Wildly Inappropriate.	Posted - 2009.03.18 21:18:00 - [9] Originally by: Ki Tarra *IMPORTANT* Keep a copy of your QR data dump. ALL NPC Attributes have been removed from the Apoc data dump. ---------------------------------- -- REMOVED IN APOCRYPHA ---------------------------------- -- All dgmTypeAttributes records for category = 11 (entities) or group = 988 (wormholes) smacks CCP Bad devs! No cookie for you! ---- FREE Explorer Lead Megalomanic EVE Null-Sec Player Influence Map http://dl1.eve-files.com/media/corp/Veritefw/FWinf
Tkar vonBiggendorf Gallente Snake Eyes Inc	Posted - 2009.03.18 22:16:00 - [10] Originally by: Ki Tarra *IMPORTANT* Keep a copy of your QR data dump. ALL NPC Attributes have been removed from the Apoc data dump. I still have the Trinity dump, as in QR they removed the NPC sell orders. Have you ever asked yourself, "Where in New Eden can I find a Mobile Medium Warp Disruption I Blueprint?" I can understand not wanting to supply certain new data items, but it makes no sense to suppress previously-supplied information from the new dumps. I promise nothingÖ. --CCP Prism X
Rilwar 22nd Black Rise Defensive Unit	Posted - 2009.03.18 22:25:00 - [11] Originally by: Tkar vonBiggendorf Originally by: Ki Tarra *IMPORTANT* Keep a copy of your QR data dump. ALL NPC Attributes have been removed from the Apoc data dump. I still have the Trinity dump, as in QR they removed the NPC sell orders. Have you ever asked yourself, "Where in New Eden can I find a Mobile Medium Warp Disruption I Blueprint?" I can understand not wanting to supply certain new data items, but it makes no sense to suppress previously-supplied information from the new dumps. Do you perchance have a location where I can snag the Trinity DB? I lost mine when my last server decided to blow up. ---O-H--S-H-I-T---
Tarak Nor	Posted - 2009.03.18 22:45:00 - [12] Edited by: Tarak Nor on 18/03/2009 22:50:18 Anyone know if there's a Linux/Mac friendly version of this data available? I'm not fussy, MySQL, PostgreSQL or just a bunch of CSV files are all good. Edit: Erm, ignore me. I should have read the first reply!
KnifeOrSpoon	Posted - 2009.03.19 02:22:00 - [13] awesome! I am beginning the MSSQL to MySQL conversion as we speak.
EveDataCore	Posted - 2009.03.19 04:38:00 - [14] Edited by: EveDataCore on 19/03/2009 04:41:41 Here are the download links: Server to Server download files - (uncompressed for easy imports): http://evedatacore.com/apoc_db/eveonline_tables.sql (43KB) http://evedatacore.com/apoc_db/eveonline_db.sql (603MB) Server to PC - (compressed in rar for those who want the data locally and are bandwidth frugal): http://evedatacore.com/apoc_db/eveonline_apoc_db.rar (47MB) Note: In roughly an hour I will reopen the URL - Negotiating some bandwidth for these downloads.
neoe77	Posted - 2009.03.19 07:17:00 - [15] i made a csv dump: eveexp2.7z (34.4MB) --------- check path using eve-path-find
DeTox MinRohim Madhatters Inc. The Initiative.	Posted - 2009.03.19 07:36:00 - [16] Edited by: DeTox MinRohim on 19/03/2009 07:37:08 http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1019071&page=2#38 Originally by: DeTox MinRohim Edited by: DeTox MinRohim on 18/03/2009 12:36:41 A first MySQL dump done from the current available dump, consider this as a preview as I'm not the expert converting from SQLServer... importing it (in windows mysql command line) worked for me. Apocrypha_1.0.0.84609_MySQL_preview.rar - Direct link Apocrypha_1.0.0.84609_MySQL_preview.rar - Eve-Files Have fun! ------ This sig space is Read-only ! omgalink - Online Skillsheet
Catari Taga Centre Of Attention Rough Necks	Posted - 2009.03.19 10:34:00 - [17] Originally by: Rilwar Do you perchance have a location where I can snag the Trinity DB? I lost mine when my last server decided to blow up. http://ccp.vo.llnwd.net/o2/data/trinity_1.0_sql.zip
Alesk Remo Amarr Corpus Prometheus	Posted - 2009.03.19 11:48:00 - [18] Guys, please help. Whenever I try and restore this database into MS SQL 2008 I get an error while trying to load the file into the restore process (that's before even starting the restore!) The error I get is: Quote: Cannot open back device 'C:\Apocrypha_1.0.0.84609_db.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 1815). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) Any help getting this database restored will be appreciated! Regards, Alesk Remo
Yskuma Caldari Flashpoint Alpha Corp.	Posted - 2009.03.19 11:54:00 - [19] Originally by: Alesk Remo Guys, please help. Whenever I try and restore this database into MS SQL 2008 I get an error while trying to load the file into the restore process (that's before even starting the restore!) The error I get is: Quote: Cannot open back device 'C:\Apocrypha_1.0.0.84609_db.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 1815). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) Any help getting this database restored will be appreciated! Regards, Alesk Remo I've seen errors like that when the SQL server user account doesn't have rights to the backup file. Try putting the file in the SQL Backups folder and restoring from there. The folder is normally something like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup .
Alesk Remo Amarr Corpus Prometheus	Posted - 2009.03.19 12:04:00 - [20] Quote: Originally by: Alesk RemoGuys, please help. Whenever I try and restore this database into MS SQL 2008 I get an error while trying to load the file into the restore process (that's before even starting the restore!) The error I get is: Quote: Cannot open back device 'C:\Apocrypha_1.0.0.84609_db.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 1815). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) Any help getting this database restored will be appreciated! Regards, Alesk Remo I've seen errors like that when the SQL server user account doesn't have rights to the backup file. Try putting the file in the SQL Backups folder and restoring from there. The folder is normally something like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup . Awesome! That worked. Thanks! --- Visit EVE Mag Today!
tesadf sfasfawef	Posted - 2009.03.19 15:46:00 - [21] Edited by: tesadf sfasfawef on 19/03/2009 15:48:42 Originally by: neoe77 i made a csv dump: eveexp2.7z (34.4MB) Hooray, just what I needed. Thanks Whoops, wrong character...ah well he's being deleted soon anyway. Um, just one thing - invNames seems to be missing.
neoe77	Posted - 2009.03.19 19:00:00 - [22] Originally by: tesadf sfasfawef Edited by: tesadf sfasfawef on 19/03/2009 15:48:42 Originally by: neoe77 i made a csv dump: eveexp2.7z (34.4MB) Hooray, just what I needed. Thanks Whoops, wrong character...ah well he's being deleted soon anyway. Um, just one thing - invNames seems to be missing. there's eveNames and invTypes but no invNames, did you make a mistake? --------- check path using eve-path-find
Got Lock	Posted - 2009.03.19 19:29:00 - [23] MOST KILLBOARDS are running mysql ver 4+, the new dump is version 5+ and wont work. Any one have a sql dump for version 4+????
DeTox MinRohim Madhatters Inc. The Initiative.	Posted - 2009.03.19 19:53:00 - [24] Originally by: Got Lock MOST KILLBOARDS are running mysql ver 4+, the new dump is version 5+ and wont work. Ah? No. and if it's the case, they should really update then. Mine runs on 5+. The dump has fields that as-is are incompatible for even some version of MySQL. So either we go through all these fields (not that there is much necessarily) and change them to text... or we stick to a recent MySQL version. None of the current existing applications including the killboard should be glued to MySQL 4. If it's the case... no comments. New MySQL dump (v5... sorry) coming with the field size fixed. ------ This sig space is Read-only ! omgalink - Online Skillsheet
Got Lock	Posted - 2009.03.19 20:14:00 - [25] Originally by: DeTox MinRohim Originally by: Got Lock MOST KILLBOARDS are running mysql ver 4+, the new dump is version 5+ and wont work. Ah? No. and if it's the case, they should really update then. Mine runs on 5+. The dump has fields that as-is are incompatible for even some version of MySQL. So either we go through all these fields (not that there is much necessarily) and change them to text... or we stick to a recent MySQL version. None of the current existing applications including the killboard should be glued to MySQL 4. If it's the case... no comments. New MySQL dump (v5... sorry) coming with the field size fixed. So upgrade or DIE? Too bad I cant just up and upgrade to mysql 5+ I have a db on my server thats over 800 megs, and lots of custom configs.... I wish I could just upgrade my box... I am pretty sure lots of KB's are running on mysql 4+.... last patch, we were able to get proper DUMP files. but now that Apoc is out, seems there is not much support for 4+ mysql... oh well.... :)
DeTox MinRohim Madhatters Inc. The Initiative.	Posted - 2009.03.19 20:25:00 - [26] Originally by: Got Lock So upgrade or DIE? A bit harsh but you're right that some hosts still run 4.X. Killboard running on it doesn't mean that they are incompatible. Mine is based on the EDK from 2006 and it runs fine. The preview dump should work for you though or it's probably some options in the dump that are not 4+ because the INSERT themselves shouldn't be any problem. I was about to delete it as I'm uploading the fixed one (5) but I guess I'll leave it there until you confirm. ------ This sig space is Read-only ! omgalink - Online Skillsheet
Got Lock	Posted - 2009.03.19 20:35:00 - [27] Originally by: DeTox MinRohim Originally by: Got Lock So upgrade or DIE? A bit harsh but you're right that some hosts still run 4.X. Killboard running on it doesn't mean that they are incompatible. Mine is based on the EDK from 2006 and it runs fine. The preview dump should work for you though or it's probably some options in the dump that are not 4+ because the INSERT themselves shouldn't be any problem. I was about to delete it as I'm uploading the fixed one (5) but I guess I'll leave it there until you confirm. SUper can I convo you in game..? I need help getting this KB upto speed. Hell its not even my KB but my ex corps :) I am just supposed to be HOSTING IT not running it, but I am a nice guy :)
DeTox MinRohim Madhatters Inc. The Initiative.	Posted - 2009.03.19 20:39:00 - [28] v1.1 MySQL 5 - Fixed varchar size and separated table dump from data. SQL Files Eve-Files: Apocrypha_1.0.0.84609_MySQL_1.1.rar Torrent: Apocrypha_1.0.0.84609_MySQL_1.1.rar XML Version incoming ------ This sig space is Read-only ! omgalink - Online Skillsheet
Rilwar 22nd Black Rise Defensive Unit	Posted - 2009.03.19 22:13:00 - [29] Originally by: DeTox MinRohim Edited by: DeTox MinRohim on 19/03/2009 20:55:54 v1.1 MySQL 5 - Fixed varchar size and separated table dump from data. Stuff. Will seed for the night... gotta shutdown the computer tomorrow. /me will be seeding the MySQL Torrent as well. Originally by: Catari Taga Originally by: Rilwar Do you perchance have a location where I can snag the Trinity DB? I lost mine when my last server decided to blow up. http://ccp.vo.llnwd.net/o2/data/trinity_1.0_sql.zip You sir, are the ****. <3 ---O-H--S-H-I-T---
corestwo Goonfleet Investment Banking	Posted - 2009.03.19 22:30:00 - [30] Originally by: neoe77 Originally by: tesadf sfasfawef Edited by: tesadf sfasfawef on 19/03/2009 15:48:42 Originally by: neoe77 i made a csv dump: eveexp2.7z (34.4MB) Hooray, just what I needed. Thanks Whoops, wrong character...ah well he's being deleted soon anyway. Um, just one thing - invNames seems to be missing. there's eveNames and invTypes but no invNames, did you make a mistake? Perhaps. I'll have to go back over them.

Pages: [1] 2 3 :: 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.