These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page12
 

SDE for Odyssey 1.0 + conversions by yours truly

First post
Author
Golden Gnu
The Golden Gnu Corp
#21 - 2013-06-05 09:30:52 UTC
@Steve
Thank you for saving me from setting up a MsSQL server
...you're awesome! Big smile

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"

Some Rando
University of Caille
Gallente Federation
#22 - 2013-06-05 18:50:49 UTC
Can we get this in json format?

CCP has no sense of humour.

Tonto Auri
Vhero' Multipurpose Corp
#23 - 2013-06-05 23:50:17 UTC
Some Rando wrote:
Can we get this in json format?

Get what in JSON format?.... How would you operate on 270Mb JSON file?

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison

Some Rando
University of Caille
Gallente Federation
#24 - 2013-06-06 01:10:47 UTC
Tonto Auri wrote:
How would you operate on 270Mb JSON file?

It was mostly a joke, but you wouldn't operate on it, you'd import it.

CCP has no sense of humour.

Ydnari
Estrale Frontiers
#25 - 2013-06-06 12:59:22 UTC
The last couple of patches have changed industry data (namely on the Capital Rigs) - are CCP going to re-issue an updated static dump to match?

--

Kaladr
Viziam
Amarr Empire
#26 - 2013-06-06 15:50:57 UTC
Steve Ronuken wrote:
Kaladr wrote:
To ease the load on the origin, these are being mirrored to:

https://eve-central.com/dumps/static_data_export/odyssey-1.0/



I'm not suffering any bandwidth issues, but this would be handy for people closer to the eve-central server Smile


Its over a factor of 100 speed difference for me :-)

Creator of EVE-Central.com, the longest running EVE Market Aggregator

ghadu rom
Sebiestor Tribe
Minmatar Republic
#27 - 2013-06-09 16:58:22 UTC
Thanks Steve Ronuken,

I used the mysql conversion file, unzipped it, I didn't know what the .dmp file was, took a look and it looked like a .sql, so i renamed the file extension.

did the following commands:

mysqladmin.exe -u root create eve_odyssey

mysql.exe -u root eve_odyssey < mysql55-odyssey-1.0-89097.sql


loaded up phpMyAdmin and it was there :)



My question is, by doing it this way did I miss something with regards to information by ignoring the yaml files?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#28 - 2013-06-09 18:51:45 UTC
ghadu rom wrote:
Thanks Steve Ronuken,

I used the mysql conversion file, unzipped it, I didn't know what the .dmp file was, took a look and it looked like a .sql, so i renamed the file extension.

did the following commands:

mysqladmin.exe -u root create eve_odyssey

mysql.exe -u root eve_odyssey < mysql55-odyssey-1.0-89097.sql


loaded up phpMyAdmin and it was there :)



My question is, by doing it this way did I miss something with regards to information by ignoring the yaml files?


The yaml files do contain some information, like which icon is used for what thing.

It's information that I've never needed though.

And yes, the .dmp file is just sql, so what you did was exactly right. I'm just in the habit of calling them dmps (dumps) from working with oracle. Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Byrrssa Crendraven
Anti - Social
#29 - 2013-06-10 17:31:21 UTC  |  Edited by: Byrrssa Crendraven
I'm using the sql code from http://wiki.eve-id.net/Published_Blueprints to get all the bps from the sde...but, I've noticed that it's not pulling any of the ships from the db. Is it something I'm doing wrong? Or, is there something that I need to update for script to be able to include the ships?

Thanks in advance.


*edit - Resolved: Apparently, if you include the icon/graphic information in the script, it won't list the ships for some reason.
Dei
Cosmic Core Industries
#30 - 2013-06-11 11:44:55 UTC
Just want to reply to say that the postgresql dump is working fine. Could you confirm if you be including the PG dump with every SDE release from now on? If so, you are awesome. Big smile
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#31 - 2013-06-11 11:46:23 UTC  |  Edited by: Steve Ronuken
Umm, sure? It was fairly simple to get working. If I don't do it in the next, it'll just be because I forgot. If that happens, just poke me.

(As long as I don't lose the tool chain. hmm time to go back it up)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Dei
Cosmic Core Industries
#32 - 2013-06-11 13:58:41 UTC
Yeah I know that it's relatively simple to do, but it seemed like it would take more time than I was willing to put in to make sure the transfer was bug free. It seems you did that easily though (I guess that's through experience of DB migrations in other technologies).
Previous page12