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.
 

Static Data dump MySql
Author
Previous Topic Next Topic
Louis Vitton
Viziam
Amarr Empire
#1 - 2011-10-21 01:23:18 UTC
Hey guys,

I am looking for a eve online incursion static data dump with no extended inserts for MySql as i am trying to upload this using big dump and due to the extended inserts it fails time and time again.

Cheers Louis
Tonto Auri
Vhero' Multipurpose Corp
#2 - 2011-10-21 09:11:04 UTC
Ask your hosting provider to import it.
Or load it into your local database and dump all the way you want.
But I warn you that due to the size of the dump, you likely won't be able to upload it through web-tools, like phpMyAdmin, either way.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Desmont McCallock
#3 - 2011-10-21 11:10:10 UTC
Tonto Auri wrote:
Ask your hosting provider to import it.
But I warn you that due to the size of the dump, you likely won't be able to upload it through web-tools, like phpMyAdmin, either way.


True, phpMyAdmin gave me some bad headaches myself. So I abandoned it.
Callean Drevus
Perkone
Caldari State
#4 - 2011-10-21 16:10:14 UTC
Use HeidiSQL, works perfectly. Much better than phpMyAdmin!

Developer/Creator of EVE Marketeer
Trenker
#5 - 2011-10-23 15:35:07 UTC
Louis Vitton wrote:
I am looking for a eve online incursion static data dump with no extended inserts for MySql as i am trying to upload this using big dump and due to the extended inserts it fails time and time again.


I don't know about such a dump. The best would be to ask your provider to import it, just as Tonto Auri already said. The other way would be his second suggestion: Import it locally (you do know XAMPP, right? Blink ) and create several SQL files you can upload and import anyway you like.

If no tools create the right dumps for you, you could easily write a small script that writes you nice and small SQL files. I imagine that as being rather anoying though.
Lavoslav Penkala
Appetite 4 Destruction
#6 - 2011-10-25 21:21:44 UTC
Maby this:

Quote:

mysql -uusername -p databasename<1.sql
With this one you will have to type and enter password for every single sql file you have.

or from mysql prompt
mysql> insert <1.sql
mysql insert <2.sql etc)
Louis Vitton
Viziam
Amarr Empire
#7 - 2011-10-26 10:11:47 UTC
Thank for the help guys I have ended up using "HeidiSQL" it is a great little application.