Trouble with setting up server

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Mar 2004
Posts: 765
Reputation: Phaelax is on a distinguished road 
Solved Threads: 38
Phaelax Phaelax is offline Offline
Master Poster

Trouble with setting up server

 
0
  #1
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
  1. [mysqld]
  2. prompt = mysql\\_\v>\\_
  3. port = 3306
  4. basedir = C:/MySQL/MySQLServer41/
  5. datadir = C:/MySQL/storage/DATA/
  6. innodb_data_home_dir = C:/MySQL/storage/DATA/ibdata/
  7. innodb_log_group_home_dir = C:/MySQL/storage/DATA/iblogs/
  8. innodb_data_file_path = ibdata1:10M:autoextend
  9. # Make table names case sensitive.
  10. 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?
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MS SQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC