Page 1 of 1

Errors loading new DB

Posted: Fri 12 Jan 2007 10:29 am
by II/JG77Hawk_5
You may have errors in loading the new DB as I did.
I got an error when loading the SEDB30-MySQL-Unix.sql file.
The error log file showed error :2013 at line 143956.

I am using SQLyog to manage database.

I was running MySQL V4.1 on server.

I got it to finally load by:

Stopping the SQL service.

Downloaded MySQL V5 and installed.

Renamed My-Medium.ini to My.ini and made changes to the file.
Here is a segment of the ini file that I changed based on fixes I found on "error:2013".

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 20M
max_allowed_packet = 100M (default value is 2M)
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512k
myisam_sort_buffer_size = 8M


Also added:
#sets mysql to be case sensitive with table names for compatability between #systems
lower_case_table_names=0


Database then loaded ok correctly with no problem

Posted: Thu 18 Jan 2007 7:18 am
by II/JG77Hawk_5
Got this error when loading KhalkhinGol Lite sql file.

Loaded StructDB ok then GenDATA ok then file above and get this error. Cleared DB and repeated, got the same thing again.

copied from error log:

Error occured at:2007-01-18 22:11:17
Line no.:579
Error Code: 1054 - Unknown column 'ID' in 'field list'

Hawk_5

Posted: Thu 18 Jan 2007 8:55 am
by IV/JG7_4Shades
Yes, a couple of errors snuck through in the SPLIT files. A new SEDB30a-SPLIT (v2) has been released for download. This should work better.

Apologies!

4Shades