Saturday, October 09, 2004

MySQL Log

To get MySQL to log all it’s actions, turn on “log-bin” (see the MySQL documentation). To turn this on in EasyPHP, open the MySQL config file, add the line e.g. “set-variable=log-bin=C:\mysqllog\”, and restart MySQL. When you want to examine a file, MySQL will not let it go if in use, so you can restart MySQL so it switches to a new file, and then look at the old file.

No comments: