Need a good example of "my.cnf" file 1

[powahusr]

I'm learning MySQL through an online tutorial, I'm currently learning how to Configure MYSQL on a Win 2000 system. I'm a little stumped in regards to configuring the "my.cnf" file. The instructions provided to modify the file are really not that helpful. The instructions point out "Hard Returns, Line Feeds and Directives" which one must be careful of when making a modification. A user is also asked to make changes to directories by seperating directories with forward slashes and puting slashes on the end of directory names.

When I open the file "my.cnf" with Notepad, the text is rather cryptic and hard to edit. Can someone please clarify, as the tutorial doesn't show an example of a known working "my.cnf" file. If possible, can you please paste an example of a working config file, or at least point me to a good example on the Web somewhere?

Thanks in Advance

 

[inlandpac]

Here you go:

[tt]<sup># Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

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

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
default-character-set=latin1
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800

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

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

[mysql]
no-auto-rehash

[isamchk]
set-variable= key=16M

[client_fltk]
help_file= c:\mysql\sql_client\MySQL.help
client_file= c:\mysql\MySQL.options
history_length=20
database = test
queries_root= c:\mysql\queries
last_database_file= c:\mysql\lastdb</sup>[/tt]

Chad. ICQ: 54380631