EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » mysql SDE conversion for Inferno 1.1 (+xls/csv)

Topic is locked indefinitely.

mysql SDE conversion for Inferno 1.1 (+xls/csv)
Author

Previous Topic Next Topic

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#1 - 2012-06-26 21:58:13 UTC | Edited by: Steve Ronuken

Main file is:
http://www.fuzzwork.co.uk/dump/mysql55-inferno11-extended.sql.bz2

Which is a regular mysql dump, with extended inserts. Not the best if you're loading it over the web, but otherwise the best one to use.

There's also:
http://www.fuzzwork.co.uk/dump/mysql55-inferno11.tar.bz2 , which is the structure + the data, in 2 different files. slower to import, but phpmyadmin should be able to resume an import with it.

http://www.fuzzwork.co.uk/dump/inferno11/
XLS/CSV(for the bigger tables) extracts
SQL files for individual tables.

Finally:
http://www.fuzzwork.co.uk/dump/mysql55-inferno11-postgrescompat.sql.bz2

which is a 'postgresql compatible' mysql dump.

(yes, they're not all available yet. but within half an hour of this post, they should be)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Tanaka Stuff and Supplies 4
Takahiro Tanaka Tanaka Stuff and Supplies Likes received: 4	#2 - 2012-06-27 11:10:24 UTC Awesome, thank you Sir ! I get 404 on the 2nd File: The requested URL /dump/mysql55-inferno11.tar.bz2, was not found on this server.


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#3 - 2012-06-27 11:28:48 UTC Takahiro Tanaka wrote: Awesome, thank you Sir ! I get 404 on the 2nd File: The requested URL /dump/mysql55-inferno11.tar.bz2, was not found on this server. It'll work now. It had used the comma following the url as part of the file name Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter

circle of lost souls 0
NephelimSeelenfeuer circle of lost souls Likes received: 0	#4 - 2012-07-07 06:44:54 UTC Steve Ronuken wrote: Main file is: Finally: http://www.fuzzwork.co.uk/dump/mysql55-inferno11-postgrescompat.sql.bz2 which is a 'postgresql compatible' mysql dump. This File doesn't seem to exists, I get an 404-Error on the URL.

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#5 - 2012-07-07 19:37:45 UTC

NephelimSeelenfeuer wrote:

Steve Ronuken wrote:

Main file is:

Finally:
http://www.fuzzwork.co.uk/dump/mysql55-inferno11-postgrescompat.sql.bz2

which is a 'postgresql compatible' mysql dump.

This File doesn't seem to exists, I get an 404-Error on the URL.

I could have sworn I'd created this one. What?

Looks like I didn't though. It's there now.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

The Redneck Gun Club 9
Xaniff The Redneck Gun Club Likes received: 9	#6 - 2012-07-08 07:30:24 UTC Thank you very much! What tool do you use to create these? Personally, I figured out how to import the SQL backup into MSSQL, but I can't for the life of me figure out how to export it to anything importable by MySQL.

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#7 - 2012-07-08 08:05:47 UTC

The initial heavy lifting is taken care of by the mysql migration toolkit. though it screws up some of the table creation, by using tinyints, where it should use ints.

And the sql it spits out won't import cleanly for some reason. something to do with line length I think. So I run that through a splitter before loading it into mysql.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

The Golden Gnu Corp 212
Golden Gnu The Golden Gnu Corp Likes received: 212	#8 - 2012-07-18 08:10:10 UTC Thank you for your hard work, creating this! Creator of jEveAssets - the asset manager "Download is the meaning of life, upload is the meaning of intelligent life"

EVE University Ivy League 1,239
Scrapyard Bob EVE University Ivy League Likes received: 1,239	#9 - 2012-07-31 21:31:17 UTC Steve Ronuken wrote: Finally: http://www.fuzzwork.co.uk/dump/mysql55-inferno11-postgrescompat.sql.bz2 which is a 'postgresql compatible' mysql dump. Yeah, pgsql 8.1 does not like that import at all. What version of pgsql did you test against to load this?