| Pages: 1 :: [one page] |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Cytech
Caldari
StrikerCorp
   |
Posted - 2008.07.31 07:18:00 -
[1]
Edited by: Cytech on 31/07/2008 07:18:19
can any one convert the new data export to mysql?
Linkage for anyone who missed the blog.
|
Ambo
Dirty Deeds Corp.
Axiom Empire
|
Posted - 2008.07.31 07:28:00 -
[2]
Already done by bunjiboys: Eve-Dev
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Cytech
Caldari
StrikerCorp
|
Posted - 2008.07.31 08:19:00 -
[3]
nice one cheers.
|
Dragonaire
Caldari
Corax.
|
Posted - 2008.08.07 20:14:00 -
[4]
Only problem their site is down now so we need another source if someone has some bandwidth.
--
Finds camping stations from the inside much easier.
Been known to write some PHP code for API from time to time too. |
Ambo
Dirty Deeds Corp.
Axiom Empire
|
Posted - 2008.08.08 07:56:00 -
[5]
It's up atm. Sure would be nice to have a backup somewhere though.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Dylan McKai
Divinity Within
Tread Alliance
|
Posted - 2008.08.08 08:06:00 -
[6]
Do I need to load all those files from bunjiboys?
Could someone please tell me how to go about importing all the data once it's downloaded? I can't restore them in MySQL Administrator :(
|
Dragonaire
Caldari
Corax.
|
Posted - 2008.08.08 17:44:00 -
[7]
If I can ever get them I'll be able to tell you I think but I'm still can't connect to bunjiboys for download. If I could get them from someone I'd put them up some where else myself so we have second source. I'm sure I have some extra webspace and bandwidth for them for a while anyway. Was hoping chucker have the update ones on his site but didn't see them there either. 
--
Finds camping stations from the inside much easier.
Been known to write some PHP code for API from time to time too. |
Ouroborus777
|
Posted - 2008.08.08 21:53:00 -
[8]
I have a couple terabytes per month of bandwidth available so I guess I can host some of the files for a bit.
The only one you actually need for importing to mysql is "ea10-mysql5.sql.bz2" (linked to my copy).
I used the linux command 'mysql' to help import it since the web interface can't generally handle the volume of data involved.
|
Valarkin
|
Posted - 2008.08.09 04:40:00 -
[9]
I've just posted both an Access 2000 mdb version and a CSV text version and an additional mirror of bunjiboy's mySQL version.
|
Dragonaire
Caldari
Corax.
|
Posted - 2008.08.09 05:18:00 -
[10]
Dylan here's a quick example how to import from command line and Ouroborus777 is right you'll want to do it that way it's much to big to do it any other way.
mysql -u yourusername -p databasename </path/to/empyrean_1.0-mysql5.sql
Just change the username, database, and path info for file. You can also use same command if windows hosted if you can find someone that gives you that type of access. Path would need to use other slashes of course  .You'll need to make sure you've already made a blank database before using this command since there no create DB in the file. Also it'll take a few minutes to finish so go get some coffee or something while you wait 
BTW thanks guys for offering to mirror files and for the other versions Val I'm sure someone will find them useful.
--
Finds camping stations from the inside much easier.
Been known to write some PHP code for API from time to time too. |
|
|
Dylan McKai
Divinity Within
Tread Alliance
|
Posted - 2008.08.09 11:04:00 -
[11]
Thanks Dragonaire. I'll give it a go :) Cheers.
|
Dylan McKai
Divinity Within
Tread Alliance
|
Posted - 2008.08.11 16:02:00 -
[12]
I got it to work eventually. I didn't know you had to run this from the OS command line and not the MySQL command line. Weird.
I am running on Windows Server 2003 so I also moved the .sql file into the same directory as mysql.exe to save worrying about the path.
Thanks again.
|
Dragonaire
Caldari
Corax.
|
Posted - 2008.08.11 19:05:00 -
[13]
There is a way to do it in mysql too i believe just never done it that way. LOAD DATA INFILE path/to/file I believe is command. Not sure how well it works with large imports like this one is.
--
Finds camping stations from the inside much easier.
Been known to write some PHP code for API from time to time too. |
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2008.08.12 21:16:00 -
[14]
No.
LOAD DATA INFILE
is to import data from CSV files.
From mysql command prompt, it is
> \. /path/to/script.sql
Don't forget to select database first.
> \u database
or
> use database;
Also, you *CAN* import this file using MySQL Administrator. Use "Backup restore" tab and play around with options.
--
Thanks CCP for cu |
|
|
| |
|
| Pages: 1 :: [one page] |