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 and IEC for Crucible 1.1 (now with DB conversions)
Author
Previous Topic Next Topic
Aineko Macx
#21 - 2012-02-08 18:57:28 UTC  |  Edited by: Aineko Macx
I noticed none of the MySQL InnoDB dumps contain foreign keys, so I made a script that adds them.

I took Jercy's MyISAM dump as base. It should also work with Luminocity's if you skip the first batch of statements that convert to the InnoDB engine. Desmont's dump is missing all indexes except primaries.

http://pastebin.com/5dS84J8X

Note the script is quite I/O intensive and runs for a while.

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Cyerus
University of Caille
Gallente Federation
#22 - 2012-02-08 20:25:03 UTC
Voted for sticky (as usual with database dump!).

Thanks again guys Big smile
morrosis
Ministry of War
Amarr Empire
#23 - 2012-02-08 21:34:23 UTC  |  Edited by: morrosis
Thank downloading now.

I also downloaded Xampp, now when I go to import the file, I get an error telling me the file is too big?
Aineko Macx
#24 - 2012-02-09 06:35:26 UTC  |  Edited by: Aineko Macx
You are probably trying to import via phpMyAdmin, which is contrained by upload size limits and whatnot.
I normally import dumps via the mysql command line client. Should be included in xampp under xampp\mysql\bin. Usage:
mysql -u dbusername -p dbname < dump.sql

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Moebius27
Deep Core Mining Inc.
Caldari State
#25 - 2012-03-07 21:01:41 UTC
Aineko Macx wrote:
Usage:
mysql -u dbusername -p dbname < dump.sql


this is definitly the best way to import massive data.
6ie
The Kiwis
#26 - 2012-03-14 19:24:45 UTC
Paying top dollar for a MYSQL conversion of the latest dump http://content.eveonline.com/data/Crucible_1.5_349247_db.zip
Desmont McCallock
#27 - 2012-03-14 19:38:21 UTC
Unfortunately this time you all will have to wait for Jercy's Fravowitz versions. I'm done with DB conversions.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#28 - 2012-03-15 00:30:31 UTC
6ie wrote:
Paying top dollar for a MYSQL conversion of the latest dump http://content.eveonline.com/data/Crucible_1.5_349247_db.zip


Challenge Accepted Blink

https://forums.eveonline.com/default.aspx?g=posts&t=81559

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Magnifikus Erzverwirrer
Sniggerdly
Pandemic Legion
#29 - 2012-04-30 22:04:27 UTC
any plans on the escalation db?

if not can you give me the method/tools to do it :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#30 - 2012-04-30 22:09:20 UTC
Magnifikus Erzverwirrer wrote:
any plans on the escalation db?

if not can you give me the method/tools to do it :)

https://forums.eveonline.com/default.aspx?g=posts&t=100797

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Magnifikus Erzverwirrer
Sniggerdly
Pandemic Legion
#31 - 2012-04-30 22:16:36 UTC  |  Edited by: Magnifikus Erzverwirrer
Steve Ronuken wrote:
Magnifikus Erzverwirrer wrote:
any plans on the escalation db?

if not can you give me the method/tools to do it :)

https://forums.eveonline.com/default.aspx?g=posts&t=100797


yeah saw that but to be more specific, looking for psql version :) sry
Desmont McCallock
#32 - 2012-05-01 05:21:36 UTC
Magnifikus Erzverwirrer
Sniggerdly
Pandemic Legion
#33 - 2012-05-01 11:10:19 UTC
nice one thanks alot :)
Previous page12