>> It may not be. Do you specify this file when you start the server on >> the command line? If you don't then you need to move my.ini to the >>windows directory:
You are quite right. When I moved the my.ini file to c:\windows it worked. I assumed that it would work 'cos the mySQL installer created the file in the installation dir. Many thanks - Adam -----Original Message----- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 17:23 To: Adam Lipscombe Cc: mysql@lists.mysql.com Subject: Re: How to set trabnsaction isoloation in my.ini file Adam Lipscombe wrote: >I have MySql 4.1.12 installed on an XP box in C:\mysql. > >I have the settings below in my C;\MySql\my.ini file: > >I have the transaction-isolation set to READ-COMMITTED but the server >seems to ignore this. When the server starts up the tx_isolation as >reported by mysqladmin extended-status is REPEATABLE-READ. > >I can set it manually from the mysql command line and that works. The >tx_isolation is then reported as READ-COMMITTED. > > >Its almost as if the server is not reading the my.ini file. > > > It may not be. Do you specify this file when you start the server on the command line? If you don't then you need to move my.ini to the windows directory: "When the MySQL server starts on Windows, it looks for options in two files: the `my.ini' file in the Windows directory, and the `C:\my.cnf' file. The Windows directory typically is named something like `C:\WINDOWS' or `C:\WinNT'. You can determine its exact location from the value of the |WINDIR| environment variable using the following command: C:\> echo %WINDIR% MySQL looks for options first in the `my.ini' file, then in the `my.cnf' file. However, to avoid confusion, it's best if you use only one file. If your PC uses a boot loader where the |C:| drive isn't the boot drive, your only option is to use the `my.ini' file. Whichever option file you use, it must be a plain text file." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
