Knowledge Base

The problem
The folder C:\MySQL\data contains files that start with <mysql-bin> such as mysql-bin.0000005.
These files are generated by MySQL for transactions that are not used by IntraVue.

The solution
To prevent creation of these files you need to “comment out” two lines in the MySQL configuration file C:\MySQL\my.cnf.
The two lines are:

Log-bin = mysql-bin
Binlog_format = mixed

To comment out a line it must be prefixed with the # character. So the two lines become:

#Log-bin = mysql-bin
#Binlog_format = mixed

After saving the file, you must stop the MySQL service using the Windows’ Services Configuration dialog. This will also stop the service AutoIP i-server.
Then delete all mysql-bin.0000xx files in the MySQL\data folder and restart the MySQL and AutoIP i-server services.

Note: As from IntraVue 2.1.0b these lines are already commented out.