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.
 

total db noob needs help !
Author
Previous Topic Next Topic
Markus Copei
Doomheim
#1 - 2012-12-05 00:00:32 UTC

hey,

I know i might be asking a bit too much since ive never used MySQL but .. could somebody explain me how to load the Retribution 1.0 SDE - Mysql Conversion . dmp file ? (Or any other version convertion since i only need the solarSystemID -> name table)

I found a ton of documentation that will help me out when i will have the .dmb openned but nothing on how to actualy open it .. Ugh

thks a lot !
Muscaat
EVE Markets
#2 - 2012-12-05 00:07:08 UTC
I'm assuming you're referring to Steve Ronuken's conversion?

I'm not sure why it has a .dmp extension, but it's just a standard MySQL dump file so you can load it in to your MySQL database in any of the usual ways, e.g.

Quote:
mysql -u username -p password databaseName < mysql-retribution-1.0-82596.dmp


on the commandline, or by uploading it as a file through PHPMyAdmin or similar...

Does that help?
Louis Vitton
Viziam
Amarr Empire
#3 - 2012-12-05 02:07:34 UTC
if you only want 1 table also you can use this -> https://forums.eveonline.com/default.aspx?g=posts&m=2265681#post2265681
Markus Copei
Doomheim
#4 - 2012-12-05 02:41:11 UTC
Thks mucaat !!!

Its exactly what i needed to know !!

Also, thnks Louis but i always wanted to learn to work with databases but did not really had any good material to work on ...
i guess that problem is solved now !

thks to both of you again!