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.
 

Question about This EveLoc Dump File - Importing such a large file

Author
Previous Topic Next Topic
Alexis Prey
The Scope
Gallente Federation
#1 - 2011-09-15 02:09:42 UTC
http://eve-search.com/thread/1546755


I'd like to have the list of locationIDs, and locationNames in my database so that I can use SQL to translate them. I THINK I found the file, but even zipped it's 106mb. My max MiB is 50 to import through phpmyadmin. As a result I have 2 questions.

Why on earth is eve locations such a MASSIVE file? Like that must be like 100 thousand rows. There is NOT 100 thousand locations... is there...?

2nd, how on earth do I get this beast into my MySQL?
Johnathan Roark
Quantum Industries
#2 - 2011-09-15 02:41:53 UTC
Alexis Prey wrote:
http://eve-search.com/thread/1546755


I'd like to have the list of locationIDs, and locationNames in my database so that I can use SQL to translate them. I THINK I found the file, but even zipped it's 106mb. My max MiB is 50 to import through phpmyadmin. As a result I have 2 questions.

Why on earth is eve locations such a MASSIVE file? Like that must be like 100 thousand rows. There is NOT 100 thousand locations... is there...?

2nd, how on earth do I get this beast into my MySQL?



It contains every asteroid belt, moon, planet, station, gate, etc in EVE.

Best method is via command line: (the { is a lessthen symbol)
#mysql -u username -p databaseName{sqlfilename.sql


Second best way is there is a file called bigdump.php.

I really, really suggest the first if you have anyway to do it that way.

PS: I really, really hate these new forums, it thinks any line with a less than or greater then symbol is html which makes me think who ever wrote them is a joke.

EVEVERIFY - A recruiting API Verification and Audit Tool

Also try out Yapeal for your php api needs