Errors loading new DB
Posted: Fri 12 Jan 2007 10:29 am
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
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