mySQL
Can someone make a copy of their my.ini file and post it in a reply please?

I need to compare it to the one that unzipped from the download I just did; the one I got looks funny.

Thanks,
Chris

    YOu could look into "support-files" dir in you mysql directory where you'd find several pre-definied ini files.

    Here is sample of my-medium.ini file:

    Example mysql config file for medium systems.

    #

    This is for a system with little memory (32M - 64M) where MySQL plays

    a important part and systems up to 128M very MySQL is used together with

    other programs (like a web server)

    #

    You can copy this file to

    /etc/mf.cnf to set global options,

    mysql-data-dir/my.cnf to set server-specific options (in this

    installation this directory is /home/mysql) or

    ~/.my.cnf to set user-specific options.

    #

    One can in this file use all long options that the program supports.

    If you want to know which options a program support, run the program

    with --help option.

    The following options will be passed to all MySQL clients

    [client]
    #password = your_password
    port = 3306
    socket = /tmp/mysql.sock

    Here follows entries for some specific programs

    The MySQL server

    [mysqld]
    port = 3306
    socket = /tmp/mysql.sock
    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
    log-bin
    server-id = 1

    Uncomment the following if you are using BDB tables

    #set-variable = bdb_cache_size=4M
    #set-variable = bdb_max_lock=10000

    Point the following paths to different dedicated disks

    #tmpdir = /tmp/
    #log-update = /path-to-dedicated-directory/hostname

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

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

    [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

      Write a Reply...