Thread: my.cnf
View Single Post
  #1 (permalink)  
Old July 22nd, 2004, 05:59 PM
lamada lamada is offline
Registered User
 
Join Date: Jul 2004
Location: Toronto, Ontario, Canada.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default my.cnf

Hi everyone,

I recently picked up the book "beginning AMP web development"
to learn Apache and Mysql. I am experiencing some problems when
I try to connect to my database. I found out in one of the
postings that *.cnf files were missing in the last version of
MySQL, so I typed my.cnf as it is in the book on page 25-26, as
it was advised.
But as soon as I added "my.cnf" to my c:\ directory I got the error
message that you will find below. I have also included a copy of my .cnf file.
Please help me....

Thanks,
Jimmy.

------ ERROR --------------------------
C:\>NET START MYSQL
The MySQL service is starting.
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

C:\>
---------------------------------------



----- MY.CNF ---------------------------------------------------------

# Example mysql config file.
# Copy this file tp c:\my.cnf to set global options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here are entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
local-i-infile = 1
#socket=MySQL
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
server-id = 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following rows if you move the MySQL
      distribution to another
# location
#basedir = d:/mysql
#datadir = d:/mysql/data

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:400M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout
----------------------------------------------------------------------
Reply With Quote