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/
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.
That’s weird. I just looked at my copy, and only found one entry for that text, in invUniqueNames.
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.
nevermind, looks like the file was mangled (in the strangest way I’ve ever seen). A clean extract makes the problem go away.