SDE Release - 20170818


(Steve Ronuken) #1

Mysql Conversion
https://www.fuzzwork.co.uk/dump/mysql56-sde-20170818-TRANQUILITY.tbz2

Postgres conversion, in the evesde schema
https://www.fuzzwork.co.uk/dump/latest/postgres-20170818-TRANQUILITY-schema.dmp.bz2

Postgres conversion, in the public schema
https://www.fuzzwork.co.uk/dump/latest/postgres-20170818-TRANQUILITY.dmp.bz2

SQLite conversion
https://www.fuzzwork.co.uk/dump/latest/eve.db.bz2

everything else (CSV, mysql tables)
https://www.fuzzwork.co.uk/dump/latest/


(salacious necrosis) #2

FYI, minor error:

09:28:49 PM Restoring /home/mastley/projects/sdeimport/fz/sde-20170818-TRANQUILITY/sde-20170818-TRANQUILITY.sql
Running: mysql --defaults-file="/tmp/tmp5CuUgL/extraparams.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=evedb_20170818 < "/home/mastley/projects/sdeimport/fz/sde-20170818-TRANQUILITY/sde-20170818-TRANQUILITY.sql"
ERROR 1062 (23000) at line 1520: Duplicate entry ‘4NGK-F IX - Asteroid Belt 4’ for key ‘ix_invUniqueNames_itemName’

I guess the source data might be bad, I didn’t look.


(Steve Ronuken) #3

That’s weird. I just looked at my copy, and only found one entry for that text, in invUniqueNames.


(salacious necrosis) #4

These are the dups I see in the extraced SQL:

(40156270,‘4NGK-F IX - Asteroid Belt 4’,9),
(40156272,‘4NGK-F IX - Asteroid Belt 4’,9),

line 1520 of sde-20170818-TRANQUILITY.sql

Possible I’m losing my mind.


(salacious necrosis) #5

nevermind, looks like the file was mangled (in the strangest way I’ve ever seen). A clean extract makes the problem go away.