Originally by: Mercahnt

---

how can i view that ?

---

Originally by: Amida Ta

---

Do we also get the CSVs?

---

Originally by: dimensionZ

---

Noticed that the icon pack came in black/grey/white. But we used to have the transparent PNGs, anychance of getting that again ?

---

Quote:

---

#!/bin/bash

for file in /pathtofiles/*.sql
do
echo ===========================
echo Updating file $file
mysql -u username --password=yourpassword -D yourdatabase < $file
done

---

Quote:

---

Rendered blueprint icons are not yet available. We're working on them.

---

Originally by: Merrowinger

---

Hi there.
I found out that in this db dump there are many "test-items" in the invTypes table. Like skills that should not appear in game.
I use this table for a Tool in which the normal (gettable) items should be available but not things like test-scripts or Stargates.
In the last db dumps i could sort these things out. I dont exactly remember how i did this, but im pretty sure i have done it with help of the "published" column.
But in this dump there are things like cargo container or the velator marked with "published=false".
In the Backup of the last db dump i see the velator as "published=true".
So is this maybe an error in the db release? Or is it a misunderstanding of the "published" column by myself?

If its a misunderstanding, please tell me how i can get rid of testobjects in the invtypes table.

---

Originally by: Jack Toad

---

Made an sqlite3 version of the dump. Where I can put it to share?

---

Originally by: Flaming Candle

---

Originally by: Jack Toad

---

Made an sqlite3 version of the dump. Where I can put it to share?

---

You could try eve-files.

---

Originally by: DaOpa

---

Question for a couple of the provided tables ..

I see there is one for Agt Offer Details..
This shows all the different types of LP offers..

My question is .. would I be missing a table that shows what LP Offers go with the corps?

Or is that information just not provided .. !

K thnx

---

Originally by: Jedzias Miezekatze

---

you see the minus in the quantity value ?. May i ask if its possible you export correct data ?

---

Originally by: Cata Clysms

---

I have a little Problem to find some Attributes for my Shiplist from the Database.

I cant find:

- Structure of a Ship
- Turret Hardpoints
- Launcher Hardpoints

All other Attributes are defined in invtypes or dgmtypeattributes table.
Someone knows the location of that data?

---

Originally by: Nuran DeSiad

---

Hi,

I'm trying to create a list of implants. So far I am able to extract a list which covers the name, the description and the value and type of modifier. Now I want to add the slot in which the implant is placed to the list. But I am not able to find this. Can anyone help me out on this ?

---

Originally by: Jedzias Miezekatze

---

PhamNuwen: what kind of data-dump is that exactly ? :)
there is a mysql-binding interface or do you mean something listed on the Python Database Topic Guide ?

---

Originally by: PhamNuwen

---

Edited by: PhamNuwen on 03/01/2008 17:48:28

Originally by: Jedzias Miezekatze

---

PhamNuwen: what kind of data-dump is that exactly ? :)
there is a mysql-binding interface or do you mean something listed on the Python Database Topic Guide ?

---

I thought the whole static database as Python objects could be usefull for some 'quick and dirty' scripts.
Currently I'm not really interested to install a real database server on my PC

---

Originally by: PhamNuwen

---

I thought the whole static database as Python objects could be usefull for some 'quick and dirty' scripts.
Currently I'm not really interested to install a real database server on my PC

---

venom:~/projekte/Perl # ./dbcodegen -g oveur dbo chrRaces

Usage: ./dbcodegen [options] <db> [table]

 Database Codegenerator v0.0.0
--------------------------------------------------------------
Available generator modules:
 c
 c++
 c#
 perl
 python
--------------------------------------------------------------

 -g <generator> use <generator> instead of <c++> as codegen engine
 -d turn debugging mode on
 -n don't print content-type
 -w turns warnings on

we dont have any 'oveur'-generator you noob !
 at ./dbcodegen line 64.

Originally by: Jedzias Miezekatze

---

Edited by: Jedzias Miezekatze on 11/01/2008 01:21:36
Since python version 2.5, you can use sqlite3 DB module. You don't need any database server to use SQL requests to SQLite db.
Check here: http://www.sqlite.org/
and here: http://www.pysqlite.org/

---

Originally by: Sinister Duck

---

Just making sure I get this. Were the original SQL data and icon packs provided by the EVE Dev team or a third party?

---

Originally by: Schwigg

---

I have the MySQL version of the data dump and I'm trying to import it into a hosted database, but I'm running into a couple of issues... I'm hoping someone here can help.

1. My interface to the database is PHPMyAdmin, which has a 2MB limit on imported SQL files. I'm assuming that breaking up the SQL files will do the trick, but this will be pretty tedious when I get to some of the larger files.

2. Even for files < 2MB in size, I'm still getting errors on the lines with the /* */ text.

Is there anyone here that has been able to import these files into MySQL using PHPMyAdmin? Any tips & tricks to make the process a little easier? Unfortunately, my hosting provider does not allow for shell access, so I'm not sure I can use MySQL directly.

---

#!/bin/sh
for i in `find . -type f`
do
 echo Importing $i
 sed -e 's/dbo\.\|COMMIT;\|-- Data export copyright 1997-2007 by CCP Games\.//g;s/,true/,1/g;s/,false/,0/g' $i | sqlite3 eve.s3db
done

Originally by: Rynlam

---

Anybody know where shipBonusCC, shipBonusCC2 (and the rest of shipBonusXX# fields) relate to?

---

Originally by: Yuwan Sum

---

Didn't see the already provided sqlite version here, so I used this to convert from the mssql files:

#!/bin/sh
for i in `find . -type f`
do
 echo Importing $i
 sed -e 's/dbo\.\|COMMIT;\|-- Data export copyright 1997-2007 by CCP Games\.//g;s/,true/,1/g;s/,false/,0/g' $i | sqlite3 eve.s3db
done

Just posting this for informational purposes, the available download
is probably better.

---

Originally by: Walfadr Wreath

---

where exactly I can find agent names... ?

---

Quote:

---

Here it is: http://dl.eve-files.com/media/0712/trinity_1.0_sqlite3.db.zip [~60Mb]
PS: It's conversion of the Mysql5 version of the dump with the same keys and indexes.

---

Originally by: Nanirso Kayen

---

I'm trying to import the MySQL export into my database but want it in UTF8 and not latin1. Anyone been able to solve this? I keep getting ERROR 1046 (42000) at new lines while importing all databases at the same time.

Just importing chrCareers worked fine so thinking about importing them one by one.

---

Originally by: Raquel Smith

---

Edited by: Raquel Smith on 11/12/2007 22:18:44
Postgres 8.1 dump available here: http://dl.eve-files.com/media/corp/crudvis/trinity-postgres-8.1.zip

edit: linky

---

Originally by: Dewar Scrabulous

---

I'm working with the Access database provided in this thread trying to find an accurate count of how much minerals I can get for recycling something, as the Item Database here on eve-online.com appears to be out of date. I've found the item typeID from the invtypes table, but I'm not sure where I have to take that value to find how much of each type of mineral it provides when recycled. I'm sure I'm just missing something obvious, it's been a while since I worked with databases. Can anyone help me out?

---

Originally by: CCP Sharkbait

---

i have untrashed this bug report and i will take car

Originally by: Kaven Kantrix

---

So is it just missing from the MySQL version, but available in theMS SQL version, or did you get your data dump from someplace else?

---

Originally by: Bunyip

---

The LOLqual is a capital-sized joke

---

Originally by: Wollari

---

I'm waiting too for a new export.

---