Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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
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
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 ------ Skills |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |