SDE Release - 20170818

(Steve Ronuken) #1

Mysql Conversion

Postgres conversion, in the evesde schema

Postgres conversion, in the public schema

SQLite conversion

everything else (CSV, mysql tables)

(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.