EVE Search - EVE data export, rmr edition

All Channels

EVE General Discussion

EVE data export, rmr edition

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

Monitor this thread via RSS [?]

Author	Thread Statistics \| Show CCP posts - 12 post(s)
Amarr Menza Amarr Viziam	Posted - 2006.09.10 03:52:00 - [1] 1. Has anybody got CreateTable syntax for use with Mysql 5? Would be very nice if someone could export this so we can all use. I am working on this but if already done then will save me and others plenty of time. 2. The stations SQL file does not have the CreateTable syntax within it, in the downloads. 3. I have started a game Data Wiki here - http://wiki.triangle-solutions.com/index.php/EVE_Online Any contributions within the realms of PHP5 and MySQL 5 programming will be a help - ie has anyone written any OOP for the RMR files? Are there any other resources around for compiling tools with the RMR data? Look forward to hearing from you all, this is my first venture into these files so see what happens
Amarr Menza Amarr Viziam	Posted - 2006.09.11 14:30:00 - [2] IDS are done as follows: 3.008.416 in most cases However the first file agtAgents the ID is done as 3008416 Can someone please tell me what the correct format should be - seems to me that the former is not a good way to identify Keys - as in MySQL we cannot identify this as an INT field type. Anyway looking forward to figuring out all these quirks. ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Viziam	Posted - 2006.09.12 02:16:00 - [3] T20 Can we have our own Forum - Called 'Game Data Developers' or something. This thread seems to contain hundreds of posts that can be answered by people correctly if they were properly organised. This way I can also find the posts by yourself within this mess. ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Viziam	Posted - 2006.09.20 03:11:00 - [4] Hi What you have written has already been covered earlier. It is better if you use something like : mysql < dbo.sql this will batch import in the SQL in the fastest possible way, do this through command line and skip any tools. Though it is better to actually do through the CSV as you will still get MySQL errors if the values are not present in the SQL data. Check out my Wiki as I am doing exports of the database in MySQL 5 format that should provoke some debate at lease on how the indexing and field types should be set up. ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Viziam	Posted - 2006.09.20 03:13:00 - [5] Originally by: Matalino Originally by: Amarr Menza Can we have our own Forum - Called 'Game Data Developers' or something. Many people that are trying to develop stuff for eve will post in this forum. "A forum for threads with words like: deterministic, continuations, generators, extrapolation, vertex shader, bi-directional reflectance distribution, etc." Would be nice if we had our own specific forum shouldnt take long to set up that deals with the Data dumps exclusively. ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Freelance Co Op	Posted - 2006.09.26 06:44:00 - [6] Hi, The EVE data wiki is now coming on great quite a few of the Tables have been optimised and outputted in MySQL 5, I am now adding optimised CSV downloads and will add XML and SQL very soon. Plus a decent schema of the DB. Looking for support on this so if anyone wants to help out click below log in and get stuck in. EVE Data Help Cheers Amarr ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Freelance Co Op	Posted - 2006.09.26 09:30:00 - [7] Hi Ok show me a link to this guide please. The goal is to not provide a 'Guide' but to provide updated optimised MySQL / Postgres / any DB schemas and data exports. As you can see from EVE MySQL Exports This is starting to happen now, I find the SQL generated by CCP is not indexed correctly, the fields types are obviously all a miss - so I am simply correcting all these importing in the CSV and then exporting this out again in an optimised fashion. ------ EVE Online Devs Wiki Triangle Solutions ------
Amarr Menza Amarr Freelance Co Op	Posted - 2006.09.26 14:51:00 - [8] And there lies the problem I have been through this thread with a fine tooth comb and a lot of the ideas are laborious and sometimes incorrect, they pay no attention to what makes a DB tick the indexing and field types, they just seem to care about getting the Data loaded up. I am sure there are dozens of DBs around that are very poorly created. If you have done the porting do you want to share your schema? What DB do you use? MySQL? The point of the collaboration is for everyone to find out the best way to do things, and to create some debate. Instead of everyone doing the same thing 50% lets try and work together and make it excellent, it will save a lot of peoples time and allow some really good tools to be developed faster. ------ EVE Online Devs Wiki Triangle Solutions ------

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.