Pages: 1 [2] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Vana Gank
Gallente Nosferatu Security Foundation
|
Posted - 2007.06.07 17:12:00 -
[31]
Edited by: Vana Gank on 07/06/2007 17:14:25
Quote: mysql.exe -hMySQLServer -uMySuperUser -pMyPassword MyEveDatabase_name < DUMPFILE.sql
EDIT: Btw, you need to create the (a) database before you try to dump data into it.
-------------------------- Please adjust the map, please. Im not clever enough to figure out which way to fly. |
DaOpa
Amarr Static Corp
|
Posted - 2007.06.07 17:50:00 -
[32]
ok got the command to work
but im getting these errors poping up
ERROR 1366 (HY000) at line 88827: Incorrect string value: '\x91tap\x92 ...' for column 'description' at row 1 ERROR 1366 (HY000) at line 88834: Incorrect string value: '\x92re wi...' for col umn 'description' at row 1 ERROR 1366 (HY000) at line 88838: Incorrect string value: '\x92s own...' for col umn 'description' at row 1
any idea what im doing wrong .. ? im using MYSQL 5.0.41 verison Static Corp Website |
Vana Gank
Gallente Nosferatu Security Foundation
|
Posted - 2007.06.07 19:11:00 -
[33]
Edited by: Vana Gank on 07/06/2007 19:10:16 From what the MySQL site indicates, that is just warnings.
Quote: --- 1.15/mysql-test/r/type_date.result2007-03-16 12:15:58 +04:00 +++ 1.16/mysql-test/r/type_date.result2007-03-16 12:15:58 +04:00 @@ -99,7 +99,7 @@ DROP TABLE t1, t2, t3; CREATE TABLE t1 (y YEAR); INSERT INTO t1 VALUES ('abc'); Warnings: -Warning1264Out of range value adjusted for column 'y' at row 1 +Warning1366Incorrect integer value: 'abc' for column 'y' at row 1 SELECT * FROM t1; y 0000
Have you checked to see if you have all the tables that's been described in the relationship image & stuff?
Btw, the warnings is part of MySQL 5.x it seems. No such issues with 4.x. In any case, it may be easier for you to switch to 4.x?
-------------------------- Please adjust the map, please. Im not clever enough to figure out which way to fly. |
DaOpa
Amarr Static Corp
|
Posted - 2007.06.07 22:52:00 -
[34]
Edited by: DaOpa on 07/06/2007 22:51:56 The dump isnt working right in the newest verison of MySql !
Which verison of MySql was dump created in ? what file charset?
Static Corp Website |
DaOpa
Amarr Static Corp
|
Posted - 2007.06.08 00:23:00 -
[35]
hmm so i followed the Generals advise .. ive done a search and replace on the '' for the published column and it seems to have worked !
im still getting the other errors thou... not sure if they do anything negitive yet ..
~~
Static Corp Website |
DaOpa
Amarr Static Corp
|
Posted - 2007.06.08 13:42:00 -
[36]
How many "invtypes" entrys are there suppose to be ?
I have 14276, while going into and checking for titans like the avatar .. its missing .. only the Avatar BP is posted ... so Ive done something wrong
*cries*
Static Corp Website |
Trak Cranker
Feral Tendency Ratel Alliance
|
Posted - 2007.06.10 17:22:00 -
[37]
Originally by: DaOpa ok got the command to work
but im getting these errors poping up
ERROR 1366 (HY000) at line 88827: Incorrect string value: '\x91tap\x92 ...' for column 'description' at row 1 ERROR 1366 (HY000) at line 88834: Incorrect string value: '\x92re wi...' for col umn 'description' at row 1 ERROR 1366 (HY000) at line 88838: Incorrect string value: '\x92s own...' for col umn 'description' at row 1
any idea what im doing wrong .. ? im using MYSQL 5.0.41 verison
I think I have tracked those errors down to strings of this sort:
"... universe can ætapÆ into the..." - the two ` and ¦ it does not like. And notice how its not a ` but æ . Could be a charset problem, but I dunno.
|
DaOpa
Amarr Static Corp
|
Posted - 2007.06.11 17:13:00 -
[38]
Originally by: Trak Cranker
Originally by: DaOpa ok got the command to work
but im getting these errors poping up
ERROR 1366 (HY000) at line 88827: Incorrect string value: '\x91tap\x92 ...' for column 'description' at row 1 ERROR 1366 (HY000) at line 88834: Incorrect string value: '\x92re wi...' for col umn 'description' at row 1 ERROR 1366 (HY000) at line 88838: Incorrect string value: '\x92s own...' for col umn 'description' at row 1
any idea what im doing wrong .. ? im using MYSQL 5.0.41 verison
I think I have tracked those errors down to strings of this sort:
"... universe can ætapÆ into the..." - the two ` and ¦ it does not like. And notice how its not a ` but æ . Could be a charset problem, but I dunno.
This Dump doesnt work with Mysql 5.0 but it will work with 4 & 3 -
Ill make a Access Database Verison of the DB, and post it soon :) For the non Mysql / php type peoples(this be me kinda peoples) .. !
---------- Static Corp Website |
Fusebl0wn
Caldari Goblin Squad
|
Posted - 2007.06.13 07:33:00 -
[39]
Originally by: DaOpa
Originally by: Trak Cranker
Originally by: DaOpa ok got the command to work
but im getting these errors poping up
ERROR 1366 (HY000) at line 88827: Incorrect string value: '\x91tap\x92 ...' for column 'description' at row 1 ERROR 1366 (HY000) at line 88834: Incorrect string value: '\x92re wi...' for col umn 'description' at row 1 ERROR 1366 (HY000) at line 88838: Incorrect string value: '\x92s own...' for col umn 'description' at row 1
any idea what im doing wrong .. ? im using MYSQL 5.0.41 verison
I think I have tracked those errors down to strings of this sort:
"... universe can ætapÆ into the..." - the two ` and ¦ it does not like. And notice how its not a ` but æ . Could be a charset problem, but I dunno.
This Dump doesnt work with Mysql 5.0 but it will work with 4 & 3 -
Ill make a Access Database Verison of the DB, and post it soon :) For the non Mysql / php type peoples(this be me kinda peoples) .. !
I'm using MySQL 5.0.37 and this dump works perfectly fine for me. Imported with no errors or warnings through the MySQL console. The MySQL server I'm using is packed with WAMP5 v1.7.1. The newest version of WAMP5 (1.7.2) has MySQL 5.0.41, but I've yet to upgrade to it to try it with that particular version.
Thanks for this great resource Chruker! |
Veidtre
|
Posted - 2007.06.16 00:51:00 -
[40]
Hmm, in my market capture files I am seeing 10-12 new station IDs that I cannot find in these latest database dumps. For example, stationid "61000101".
Are these databases out of date now?
V
|
|
DarkKeeper
Viziam
|
Posted - 2007.06.17 23:34:00 -
[41]
Got a little question... Is it possible to extract a table containing only the data needed for a production calculator for instance? Sorry for my stupid newbie question _______________________________________________ |_______________________________________________| |
Dioh Kado
Galactic Fighter Syndicate G.U.A.R.D.
|
Posted - 2007.06.19 12:26:00 -
[42]
Edited by: Dioh Kado on 19/06/2007 12:25:36 Hi Chruker, first of all: GREAT JOB!
Installation on MySQL 4.1.10a works perfect and saves lots of my time.
Today REVELATIONS II will be deployed on the live-server and anyone is waiting greedy for the updated dataexport fom CCP. So my question is if you will go on providing MySQL-compatible EVE-Datadumps on you website.
regards
|
Chruker
|
Posted - 2007.06.19 19:29:00 -
[43]
Originally by: Veidtre Hmm, in my market capture files I am seeing 10-12 new station IDs that I cannot find in these latest database dumps. For example, stationid "61000101".
Are these databases out of date now?
V
Yeah, there are some stations which aren't in the database. Those should be player built outposts, that has been build since CCP released the database in december.
I'm really really really really hoping that Garthawk gets a database dump released quickly, as I'm not looking forward to manually adding all that new stuff to the database :-)
However if you provide me with those 10-12 station ids, I should be able to put something together so at least the station list is complete. However the list would be incomplete as soon as somebody builds a new outpost. Which reminds me. An up-to-date station list would be nice to be able to pull out using the new API thingy. I gotta suggest that. That and an alliance list. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Chruker
|
Posted - 2007.06.19 19:34:00 -
[44]
Originally by: Dioh Kado Today REVELATIONS II will be deployed on the live-server and anyone is waiting greedy for the updated dataexport fom CCP. So my question is if you will go on providing MySQL-compatible EVE-Datadumps on you website.
I'm going to put my conversion of the datadump on my site. However I am a bit puzzled about the troubles with importing the dump to MySQL 5. It sounds a bit like some character set thingy, but I'll need to look into that when/if the next dataexport arrives. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
Random Action
Minmatar Lost and Found
|
Posted - 2007.06.19 20:04:00 -
[45]
Edited by: Random Action on 19/06/2007 20:03:51 I have got the DB import to import clean into MySQL v5.0 but had to work around a change in MySQL since version v4.x.
In MySQL v4.x the DB engine would silently accept data that was not of the correct type for the column and "correct" it silently for you. This feature is disable by default in v5.0.
The old behaviour can be re-enabled by setting a system option at the top of the import file:
SET SESSION sql_mode = '';
see: 5.2.6. SQL Modes for reference.
I think that the mode affecting the import is "STRICT_TRANS_TABLES".
Doing the above gave me a clean import but left some tables where the values in the columns where outside the expect range e.g. should be 'true' 'false' NOT NULL but the inserted value was ''.
Hope this is of some help
|
Trak Cranker
Feral Tendency Ratel Alliance
|
Posted - 2007.06.19 20:10:00 -
[46]
Edited by: Trak Cranker on 19/06/2007 20:11:10 I had the character set problem.
Fixed it by opening the file in a decent text editor, saving it as UTF8 - and adding SET NAMES 'utf8'; at the top of the file. (It then gave me a warning about some CR/LF that it didnt like at that line when I imported - but it worked fine)
Had to put 'false' in all the empty published fields too, in the invTypes table too, but thats another problem. EDIT: See Random Action above apparently have a solution for that. Its just the published fields in the invTypes table - should be easily fixed with an update command afterwards.
|
DarkKeeper
Viziam
|
Posted - 2007.06.20 22:48:00 -
[47]
I get the following error when trying to import " ERROR 1265 (01000) at line 814486: Data truncated for column 'published' at row 1 " _______________________________________________ |_______________________________________________| |
Laodell
|
Posted - 2007.06.23 01:11:00 -
[48]
Hey Great DB no Problems.
I was wondering, whats the general timeframe for CCP to release a new Data dump after an update? Say Revelations II?
-Dell
|
Mei Linn
|
Posted - 2007.06.28 16:28:00 -
[49]
Hi Chruker,
Thanks bunches for the database export. I had some difficulty importing to MySQL 5, because my server was not automatically converting the empty string to "false" in the invTypes table. I worked around that by just doing a search and replace in that chunk of the file to replace ,'',NULL, with ,'false',NULL, (in case that helps anyone else). I tried the TRANS_TABLE thing described above, but it did not appear to have any effect. It's possible that I did not do it right.
Anyway, I had a question about the data that I was hoping someone could help me with. I've worked out how the invTypes table and the dgmTypeAttributes table are related, so I can pull out all the NPC data that I want, with one exception. I can't seem to figure out how to tie an NPC ship to the correct faction. I'm not seeing a factionID associated with the NPC row anywhere. Is there a table relationship that I'm not seeing? Thanks in advance.
|
Chruker
|
Posted - 2007.07.05 13:33:00 -
[50]
Originally by: Laodell Hey Great DB no Problems.
I was wondering, whats the general timeframe for CCP to release a new Data dump after an update? Say Revelations II?
-Dell
2-3 weeks ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering |
|
Mianda Dania
|
Posted - 2007.07.05 14:46:00 -
[51]
Originally by: Chruker
Originally by: Laodell Hey Great DB no Problems.
I was wondering, whats the general timeframe for CCP to release a new Data dump after an update? Say Revelations II?
-Dell
2-3 weeks
Mostly CCP doesn't seem to stick to linear time as we know it. Comes from dealing with all the high-tech in the game and the Jovians. Don't try to put fixed dates and lengths of time on something they do.
|
Acos Tudor
Minmatar AB INITO Proper Response
|
Posted - 2007.07.05 19:31:00 -
[52]
Thanks a lot for your database export!
After trying to import the CCP data dump into SQL Server Express, I admit I was holding my breath when I began importing your 200MB+ SQL file into MySQL. There were no errors!! You even provided a file showing relations between different tables!
I guess had the CCP done its job properly in the first place, I would not have had the opportunity to thank you. It is extremely generous of you to provide the 30MB file dump on your own website's bandwidth.
|
Govind
|
Posted - 2007.07.14 04:23:00 -
[53]
Sorry if this is the wrong place to ask but I can't seem to figure out how to get a string corporation name given a corporationID. I don't see a field for a name in the crpNPCCorporations table nor any relationship that would show it appearing in any other table. I find this to be true of agent names and other things as well.
|
zibelthurdos
Archron Dusyfe Industries
|
Posted - 2007.07.14 06:30:00 -
[54]
the names aren't in any of the CRP tables
the names are in evenames
crpNPCCorporations.corporationID = eveNames.itemID;
|
Armilein
|
Posted - 2007.10.06 02:50:00 -
[55]
is there a chance to get a csv-version of your data dump?
|
Karanth
Gallente Crazy 88's
|
Posted - 2007.10.06 03:01:00 -
[56]
Can... you feel... the NECRO... tonight.....
All that's left...
There is only one sig hijack that matters, the orginal and only member of the hijack squad. me. -Eris. ps Black russians are better then beer.
|
|
ISD Rauth Kivaro
ISD STAR
|
Posted - 2007.10.06 03:08:00 -
[57]
Hey look, a necro!
There's info on how to manage the database dumps including CSV conversion tools on http://wiki.eve-dev.net (not a CCP link or affiliated with CCP Games).
forum rules | [email protected] | Our Website
|
|
|
|
|
Pages: 1 [2] :: one page |
First page | Previous page | Next page | Last page |