Pages: 1 [2] 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 2 post(s) |
Induc
Amarr
|
Posted - 2010.05.29 18:52:00 -
[31]
Edited by: Induc on 29/05/2010 23:08:06
|
Caine Dreamwalker
Gallente The Scope
|
Posted - 2010.05.31 05:08:00 -
[32]
Thanks for dump, still waiting for PI data ^_^
|
davcin
Caldari davcin Corp
|
Posted - 2010.05.31 08:57:00 -
[33]
Any news about when the image data will be available? ____________________________________________
EVEViewer - view your journal, orders, transactions and allot more out of |
Shoorupoed
|
Posted - 2010.06.02 06:14:00 -
[34]
hlp plz... where is a skills table in this DB?
|
Qoi
New Eden Warriors
|
Posted - 2010.06.02 08:01:00 -
[35]
Originally by: Shoorupoed hlp plz... where is a skills table in this DB?
The Skills are in the invTypes table as all other item types are. JOIN with invGroups and SELECT only groups that are part of category 16 (Skills).
Anyone converted the new Datadump yet?
|
Adria Eqviis
|
Posted - 2010.06.02 11:53:00 -
[36]
temporary postgres planetschematics tables, until zofu's scripts spit out a new complete postgres dump:
http://www.diac24.net/eve/tyr101-postgres-planetschematics.sql (includes all 3 new tables)
http://www.diac24.net/eve/zzzplanetresources.sql contains schemas for planet resources and planet type resouce data
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.02 11:55:00 -
[37]
Originally by: Qoi Anyone converted the new Datadump yet?
sure.
mysql singlefile (you are most likely looking for this one) this one should also load just fine in php-webloader-scripts, if it whines about something with timestamps at the end, ignore it. you want innodb? bzcat tyr101-mysql5-v1.sql.bz2 | sed -e 's/ENGINE=MyISAM/ENGINE=InnoDB/g' | mysql
sqlite singlefile (can be used for Eve Asset Manager)
less popular:
MSsql script dump (useful for those who cba to upgrade to sql server 2008)
mysql "one file per table" dumps (for those who dont really need translations or celestial statistics)
there may or may not be other flavors i forgot about if you look here or here.
as usual, please whine if there are any issues or you need custom dumps (partial sqlite, csv, ...) or something...
hints on how to use the split materials data may be found in the dom100 thread.
note the official schematics tables are planet* instead of the scm* i used, but thats about the only difference there.
also, anyone want to bet how many people will be asking about conversions _after_ this post because they didnt bother to read the thread?
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.06.02 20:09:00 -
[38]
Edited by: Tonto Auri on 02/06/2010 20:09:44
Originally by: Jercy Fravowitz
you want innodb? bzcat tyr101-mysql5-v1.sql.bz2 | sed -e 's/ENGINE=MyISAM/ENGINE=InnoDB/g' | mysql
I don't think there's any need for InnoDB, unless you are using single database for both dump and site stuff (some hosting companies don't allow you to use more than one database per hosting, which is sucks). MySQL is slightly faster on straight SELECT operations, than InnoDB, and if you have option, better keep dump as MySQL. IMHO.
Quote: also, anyone want to bet how many people will be asking about conversions _after_ this post because they didnt bother to read the thread?
Enough to make you wonder, if brains distribution covering the earth sufficiently to catch up with population spread. -- Thanks CCP for cu |
Catari Taga
Centre Of Attention Rough Necks
|
Posted - 2010.06.02 23:26:00 -
[39]
CCP good job on the image dump, I think it's the first one I see where I did not notice any issues so far. --
Originally by: Zeke Mobius I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.
|
Qoi
New Eden Warriors
|
Posted - 2010.06.03 07:23:00 -
[40]
Originally by: Jercy Fravowitz
Originally by: Qoi Anyone converted the new Datadump yet?
sure
We love you
Oh and i think your network ban has been lifted, we really miss your links
|
|
Epitrope
The Citadel Manufacturing and Trade Corporation
|
Posted - 2010.06.03 09:14:00 -
[41]
There seem to be some some problems with the new planetary interaction item types with regard to the icons. The new icons are included in the dump (kind of), named icon96_01.png and up, but as far as I can tell they have no entries in eveGraphics -- in particular, they are not listed in eveGraphics.icon as the other icons are. Further, the invTypes.graphicID is either null or wrong for all the newly-introduced types. I've mapped them out by hand as best I could, and made a patch script: http://dl.eve-files.com/media/corp/Epitrope/pi-graphics-fix.zip
When I say the new icons are included "kind of", I mean that some of the icons included in the image dump don't quite match up with what's shown in the market window in the client. Two are actually flipped about the y-axis, several are missing the cargo emblem in the lower right, and some have a planet emblem in the lower left rather than the cargo emblem. I've included these notes in the sql file, above.
|
Yaeoa
|
Posted - 2010.06.06 11:05:00 -
[42]
CCP Zirnitra thanks. I'm looking forward to get my hands on it Jercy Fravowitz, thanks a lot for the sqlite version of the SDD.
|
Sidrat Flush
Caldari Eve Industrial Corp Celestial Tribesmen
|
Posted - 2010.06.09 06:55:00 -
[43]
Wouldn't it be nice if the datadump came in a 2008 64bit format?
Having installed that version yesterday on the work pc (shush!) I realised this morning that I would need the 32bit version if I was to ever to have fun and actually start the Tyrannis version of the EIO spreadsheet.
Ahh well, we can dream right?
Thanks for the dump CCP! View The Eve Industrial Organiser Site
|
conradesc3
|
Posted - 2010.06.09 23:39:00 -
[44]
Originally by: Jercy Fravowitz (...) the schematics data is missing. (...) also, the values _probably_ will be still different.
dbz.scmSchematics dbz.scmSchematicsTypeMap dbz.scmSchematicsPinMap
Many thanks for the schematics dump. Maybe i can save someone else's time : There is a small thing, scmschematicstypemap has references to about 65 schematicID's wich dont exist in schematics table. This may cause wierd results if you're searching schematics by typeID.
You can just view the missing entries with: SELECT * FROM scmschematicstypemap LEFT JOIN scmschematics USING(schematicID) WHERE ISNULL(cycleTime) GROUP BY schematicID you can delete with DELETE a FROM scmschematicstypemap AS a LEFT JOIN scmschematics AS b ON (a.schematicID=b.schematicID) WHERE b.schematicID IS NULL;
|
Sidrat Flush
Caldari Eve Industrial Corp Celestial Tribesmen
|
Posted - 2010.06.10 05:07:00 -
[45]
I'm getting "the media family on device is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally - Error 3241" message when I try to restore the .bak file using MS SQL Server 2008 Express 64bit, am I the only one or have I missed a small but vital step in the set up process?
View The Eve Industrial Organiser Site
|
Catari Taga
Centre Of Attention Rough Necks
|
Posted - 2010.06.10 14:48:00 -
[46]
Edited by: Catari Taga on 10/06/2010 14:48:09
Originally by: conradesc3 Many thanks for the schematics dump.
Jercy's post is outdated, you should use the official dump which contains the schematics data, in particular if Jercy's data may have been incomplete (which the official isn't). --
Originally by: Zeke Mobius I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.10 15:32:00 -
[47]
Originally by: Catari Taga Jercy's post is outdated, you should use the official dump which contains the schematics data,
yes, that.
Originally by: Catari Taga in particular if Jercy's data may have been incomplete (which the official isn't).
hahaha, good one. made my day.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.10 15:39:00 -
[48]
Originally by: Sidrat Flush I'm getting "the media family on device is incorrectly formed. SQL Server cannot process this media family.
probably just incompatible. you could try using the MSsql script dump instead of the binary backup thing.
|
Sidrat Flush
Caldari Eve Industrial Corp Celestial Tribesmen
|
Posted - 2010.06.10 16:30:00 -
[49]
Originally by: Jercy Fravowitz probably just incompatible. you could try using the MSsql script dump instead of the binary backup thing.
Well I now know it was me being a bit slow with 2008 and I was selecting the wrong type of file to retrieve, so it's sorted now, and I can begin creating the queries for all the goodies I need to update the EIO spreadsheet into a modular design.
I doubt I will ever get my head around to programming though, it's far too esoteric.
View The Eve Industrial Organiser Site
|
conradesc3
|
Posted - 2010.06.11 03:43:00 -
[50]
Edited by: conradesc3 on 11/06/2010 03:43:44
Originally by: Catari Taga Edited by: Catari Taga on 10/06/2010 14:48:09 Jercy's post is outdated, you should use the official dump which contains the schematics data, in particular if Jercy's data may have been incomplete (which the official isn't).
official dump = mssql (bleah) but anyway, i should have read the entire mysql dump post... "note the official schematics tables are planet* instead of the scm* i used, but thats about the only difference there." *doh
|
|
Catari Taga
Centre Of Attention Rough Necks
|
Posted - 2010.06.11 18:03:00 -
[51]
Edited by: Catari Taga on 11/06/2010 18:05:05
Originally by: Jercy Fravowitz
Originally by: Catari Taga in particular if Jercy's data may have been incomplete (which the official isn't).
hahaha, good one. made my day.
lol, I guess that was a carelessly open statement, but you know what I meant.
Originally by: conradesc3 Edited by: conradesc3 on 11/06/2010 03:43:44
Originally by: Catari Taga Edited by: Catari Taga on 10/06/2010 14:48:09 Jercy's post is outdated, you should use the official dump which contains the schematics data, in particular if Jercy's data may have been incomplete (which the official isn't).
official dump = mssql (bleah)
His mysql conversion of the latest official dump will do, too. --
Originally by: Zeke Mobius I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.
|
DIV Leader
|
Posted - 2010.06.14 00:50:00 -
[52]
OK, SUPPOSEDLY the official dump is for MS SQL. I've tried both 2005 and 2008 studio manager and neither can ready the BAK file. What gives.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.14 11:37:00 -
[53]
Originally by: DIV Leader OK, SUPPOSEDLY the official dump is for MS SQL. I've tried both 2005 and 2008 studio manager and neither can ready the BAK file. What gives.
SSMS 2008 should work. what kind of problem do you have?
for 2005, using the script dump should work.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.14 11:57:00 -
[54]
Originally by: Catari Taga
Originally by: conradesc3 official dump = mssql (bleah)
His mysql conversion of the latest official dump will do, too. My point was mainly that the data is now part of the official dump, and the issue you described will not occur with the official data.
depends. you may or may not be aware that the official dump does contain exactly the described problems: crud rows that violate referential integrity. sometimes missing rows. sometimes missing _tables_. columns with inconsistent types.
the conversion dance involves a "turd polishing" stage where this is being "fixed". this script usualy needs to be adjusted for every new data dump.
a lot of it got fixed or cleaned up over time, but enough of it is newly added too. and the fixes in many cases are just the same kind of "delete stuff referencing stuff not in the other table" i am doing instead of getting rid of the root cause. (well, some would miss Greyscale, i guess...)
those observed nonattached crud rows in my PI data? exactly as in the client, or in the official data.
|
DIV Leader
|
Posted - 2010.06.14 12:45:00 -
[55]
Originally by: Jercy Fravowitz
Originally by: DIV Leader OK, SUPPOSEDLY the official dump is for MS SQL. I've tried both 2005 and 2008 studio manager and neither can ready the BAK file. What gives.
SSMS 2008 should work. what kind of problem do you have?
for 2005, using the script dump should work.
I have both SSMS 2005 and 2008 installed. I only have MSSQL 2005 Server running. The script dump file is too big and won't load in either studio. It's been a while since I used sqlcmd. How do I run sqlcmd on the sql dump file?
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.06.14 19:41:00 -
[56]
Then free disk space, and you need 2008 server installed to restore from backup. -- Thanks CCP for cu |
|
Chribba
Otherworld Enterprises Otherworld Empire
|
Posted - 2010.06.16 06:31:00 -
[57]
Originally by: Tonto Auri Then free disk space, and you need 2008 server installed to restore from backup.
This. You need either 2008 server or express in order to restore the backup now.
I had no problems importing it on 2008, 2005 however won't load it without displaying similar errors as you get.
Secure 3rd party service | my in-game channel 'Holy Veldspar' |
|
Jdestars
Stars Research systems Incorporation
|
Posted - 2010.06.18 12:32:00 -
[58]
Edited by: Jdestars on 18/06/2010 12:35:21 well id some error occured too with de-compression (unflat) file archive
verify the size of the .bak =>324 693 ko
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.06.22 13:33:00 -
[59]
Originally by: Jdestars and if you use msyql migration tool you need to modify the Trntranslations
if your goal is to have the dump in mysql, why not just use the mysql conversion to begin with?
|
Spark TUExplode
|
Posted - 2010.06.23 21:28:00 -
[60]
Im trying to open the MySqL version, I have a simple question and possibly a dumb question, as this is my first time, does it require a User ID and password and if this is the case, which one is the default. Many thanks Spark
|
|
|
|
|
Pages: 1 [2] 3 4 :: one page |
First page | Previous page | Next page | Last page |