open All Channels
seplocked EVE Technology Lab
blankseplocked Importing ramTypeRequirements with SQLyog
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Jess Technite
Posted - 2011.06.18 10:01:00 - [1]
 

I'm trying to import this table into a partial database of the game but throws this error and don't know what to do.
I have set in C:\Program Files\MySQL\MySQL Server 6.0\bin> the amount of the related variable with mysql --max_allowed_packet = 512M and even with this doesn't solve the problem. If i try to do it in the "mysqld" server, in Windows 7 and setting both EXE's to "run as administrator" loads a black screen but stops there.
And haven't found the option to set this variable in SQLyog.
Have someone found this same problem and know how to solve it? There's also the pass to set the variable in the client, and doing it in mysql application should be able to import it in the command line application, but also don't know how. And first would choose to try it in a visual application like SQLyog.

Thanks in advance.

Trenker
Posted - 2011.06.19 15:17:00 - [2]
 

How do you import? What is the command you are using?

I have a mysql (xampp based) on win7 as well and it always worked for me Question

eg.:
mysql -u root -pPASSWORD eve_datadump_inc15 < inc15-mysql5-v1.sql

are you using the dump with only one table from http://zofu.no-ip.de/inc15/inc15-mysql5-sql-v1/ ?

Phoenix Torp
Caldari
Caldari Provisions
Posted - 2011.06.20 19:01:00 - [3]
 

Originally by: Trenker
How do you import? What is the command you are using?

I have a mysql (xampp based) on win7 as well and it always worked for me Question

eg.:
mysql -u root -pPASSWORD eve_datadump_inc15 < inc15-mysql5-v1.sql

are you using the dump with only one table from http://zofu.no-ip.de/inc15/inc15-mysql5-sql-v1/ ?


I try it with the dump with only one table of that link, as don't want to store the full database (only need some tables).
The import is made by an option of SQLyog GUI, not command-line, but it was solved by splitting the SQL file doing first time the declaration of the table and the others with intervals of 2000 INSERT's, that added correctly even in the Query window.

However, thx for the answer, no one knows who useful can be this. Ah, and I don't use PHP. The software I'm doing is only for me and made in VB.net


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only