These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

MySQL Dump
Author
Previous Topic Next Topic
Gaitrie
MagmaTech Industries
#1 - 2011-10-28 22:33:19 UTC
So I am going to develop something for eve - not sure what but we will see.

I have downloaded the mysql dump from this post: https://forums.eveonline.com/default.aspx?g=posts&t=6376&find=unread

Took ages to upload to the hosting provider. Now I went to http://wiki.eve-id.net/Services_provided_by_station to try out some queries and see what happens.

But each time I get an error telling me that certain tables are missing. I imported the data in the dbase of mysql - it was successful and with no errors.

I have the following tables in teh dbase: http://img847.imageshack.us/img847/3290/mysqldump.jpg

Just want to check that I have all tables in the dbase of mysql. Anyone can provide me with a list of tables ?

Mine is Bigger **than **Yours ! <<<
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#2 - 2011-10-28 23:04:29 UTC  |  Edited by: Nathan WAKE
I'm affraid you're missing a bunch of tables.

Here's my list :

List of tables

Are you sure you got the complete dump ?

PS : in my dump, a few tables are "personal" - all the phpbb_eve_something are not in the dump, as well as the "test" table. "Secret project" underway Big smile

"I'm a very good housekeeper. Each time I get a divorce, I keep the house"

Zaza Gabor
Gaitrie
MagmaTech Industries
#3 - 2011-10-28 23:53:22 UTC
indeed - no idea what I did wrong - and the dump was successful without any errors.

Going to try a local dump and see how that goes

Mine is Bigger **than **Yours ! <<<
Tonto Auri
Vhero' Multipurpose Corp
#4 - 2011-10-29 02:32:46 UTC
Do _not_ use phpMyAdmin to upload SDD to your website.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Gaitrie
MagmaTech Industries
#5 - 2011-10-29 05:52:03 UTC
Think I have it now - took me a long time to figure out.

first I followed this: http://blog.evepanel.net/eve-online/static-data-dump/get-the-static-data-dump-for-mysql.html

that gives me a full dbase with the correct tables.

Then download the mysql SDD and then inport that - that should do it. I think for some reason when I import the SDD first it does not ceate the tables it is missing.

Did some test queries from the eve api v2 website and works fine ... so far so good.

And no - using navicat to upload the files - the phpMyAdmin is no good :-)

Mine is Bigger **than **Yours ! <<<
Nathan WAKE
Deep Core Mining Inc.
Caldari State
#6 - 2011-10-29 06:25:13 UTC
Gaitrie wrote:

And no - using navicat to upload the files - the phpMyAdmin is no good :-)



Lol, you recognized that just by the look of my screenshot ? What an expert. Big smile

I use navicat for the queries and so on, but I install my dumps with the classical

mysql -h localhost -u user -p password database_name < file.sql.

Always faster to execute that locally when yo can.

"I'm a very good housekeeper. Each time I get a divorce, I keep the house"

Zaza Gabor
Gaitrie
MagmaTech Industries
#7 - 2011-10-29 07:08:40 UTC
Yep saw from the screenshot that you used navicat - have the same :-)

Not able to do it locally so will let it run while I do the cleaning and kid feeding and by the time I am done hopefuly the dbase will be populated with the right data.

Mine is Bigger **than **Yours ! <<<
Tonto Auri
Vhero' Multipurpose Corp
#8 - 2011-10-29 10:37:37 UTC
You can always ask your hosting provider to do that for you.
Just upload the data to your host and let them know, where you want them.
If they tell you to be gone... well, it's time to search for more responsible hosting provider.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Gaitrie
MagmaTech Industries
#9 - 2011-10-29 11:04:42 UTC
just did it... as it was taking way to long now

Mine is Bigger **than **Yours ! <<<
Osku Rei
Pixel 6
#10 - 2011-10-30 08:38:08 UTC
Tonto Auri wrote:
Do _not_ use phpMyAdmin to upload SDD to your website.


Why nothings wrong with myphpadmin ?

Next generation of lottery tracker coming soon! http://evelotterytracker.com/

Please like my post if it has helped you :)
Gaitrie
MagmaTech Industries
#11 - 2011-10-30 08:39:14 UTC
well with phpmyadmin the 1.4 gb .sql file will not upload at all. I just asked the provider to upload the file - easier then waiting for ages to do it

Mine is Bigger **than **Yours ! <<<
Louis Vitton
Viziam
Amarr Empire
#12 - 2011-10-31 01:58:16 UTC
you could use www.heidisql.com it will upload the static data dump though a remote connection to your SQL server, phpmyadmin can't manage it by itself as the files to large also you could use bigDump (http://drupal.org/node/43024) but that wont work for the MYsql version of the SDD as it has extended inserts which bigDump Can't deal with.

Overall Get your provider to upload it for you or use heidisql to connect remotely and do it yourself.

Heidisql can upload it without reading it, it will buffer 5 MB at a time and do it slowly will take while but it will work, I used it myself to upload to my shared host.