MS SQL

MS SQL RSS

Trouble with setting up server

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Mar 2004

Posts: 765

Reputation: Phaelax is on a distinguished road

Solved Threads: 38

Phaelax

Offline

Master Poster

Trouble with setting up server

Feb 7th, 2005

Running Win2kpro with mysql server 4.1. I installed the service "mysqld-max-nt.exe", but it won't run. It's set for automatic, but even if I try to activate it manually, it won't. I checked the event viewer and it shows only this:
"The mysql41 service terminated unexpectedly"
Could there be a problem with my config file?

my.cnf

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
[mysqld]
prompt = mysql\\_\v>\\_
port = 3306 
basedir = C:/MySQL/MySQLServer41/
datadir = C:/MySQL/storage/DATA/
innodb_data_home_dir = C:/MySQL/storage/DATA/ibdata/ 
innodb_log_group_home_dir = C:/MySQL/storage/DATA/iblogs/ 
innodb_data_file_path = ibdata1:10M:autoextend 
# Make table names case sensitive. 
set-variable = lower_case_table_names=0
[mysqld]
prompt = mysql\\_\v>\\_
port = 3306 
basedir = C:/MySQL/MySQLServer41/
datadir = C:/MySQL/storage/data/
innodb_data_home_dir = C:/MySQL/storage/data/ibdata/ 
innodb_log_group_home_dir = C:/MySQL/storage/data/iblogs/ 
innodb_data_file_path = ibdata1:10M:autoextend 
# Make table names case sensitive. 
set-variable = lower_case_table_names=0

I was following the tutorial here: http://www.analysisandsolutions.com/...asic.htm#start

When I try to connect from the prompt, I get the error code 10061.

Also, the tutorial doesn't explain what InnoDB tables are. What's the difference with them?