Re: History file on Win32 - Jacob Bezemer - com.mysql.lists.win32

6 messages in com.mysql.lists.win32Re: History file on Win32

From	Sent On	Attachments
Januski, Ken	01 May 2001 10:12
Markus Hoenicka	01 May 2001 11:27
Jacob Bezemer	01 May 2001 11:59
Januski, Ken	01 May 2001 14:08
Rene Tegel	01 May 2001 14:33
Januski, Ken	02 May 2001 20:53

Subject:	Re: History file on Win32
From:	Jacob Bezemer (beze...@cura.net)
Date:	05/01/2001 11:59:47 AM
List:	com.mysql.lists.win32

Check out your my.ini file in C:\WINNT. Mine has the following content, where the log-update will give me a log file :

#This File was made using the WinMySQLadmin 1.0 Tool #3-10-2000 21:05:48 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql log-update datadir=C:/mysql/data [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=Administrator password=password

The log-update option will give me a log file in the c:\mysql\data directory, name of "server.jjj" where server is your computer name and jjj is the julian date the server was started.

This contains all SQL-statements that change data. You can run the file straight into mysql if necessary in case of problems (you go back to your latest backup and apply this log to get all the changes back in!).

Koos

Hi,

I've been happy using MySQL on Linux but also needed to try it on NT at work because that's in many ways the only "authorized" OS. I've been fairly successful in getting it working but am going nuts not being able to use a history file to look up complex queries, inserts, etc. for reuse. Can anyone point me in the right direction in finding the history file?

Thanks,