Feature Request

[peterlaursen]

The option to save or 'spool' HISTORY to a file (and open it in HISTORY next time SQLyog is started) has been requsted before. By me-myself too! 🙂

Quite a few programs have an option to set the logfile size. When a new entry is added the oldest is removed. WINDOWS own system logging does this. Symantec AV program and others do.

With the MySQL Server you can enable binary logging if you have privilege to access the configuration. simply add “bin-log” to the configuration file. It will record any operation just like a tape recorder (of all users and all connections). There is a tool available from MySQL that lets you convert the binary log to a plain text file. There is a 'whitepaper' on that from http://www.mysql.com.

I think with MySQL 5.1 you will also be able to save the binlog in database itself. Did not have the time to research into that yet …

[Brendon Kozlowski]

bin-log creates which logging type? I just opened up my MySQL “Developers Library” book and started looking at the backup/transaction logging types…

I've found –log-bin which is the binary log.

I'm not seeing the explicit command for the binary update log…are they one in the same?

–log is the general log file.

The configuration file is the my.conf file, correct?

…back on topic, I still think this feature would be great. 😀

[peterlaursen]

I am sorry and you were right. 🙁

Add 'log_bin' to the [mysqld] section of my.ini/my.cnf or start the server with '– log-bin' option from shell. It is the same.

Yes, I would like the option to save or rather 'spool' HISTORY too. If you occasionally close the program (or if it crashes), you will lose HISTORY as of now. But I don't think it is very easy to implement now – that should have been 'concepted' like that from the beginning.

And I then would also repeat the requests that:

1) a semicolon is added to each line of HISTORY

2) there should be an option not to write the TIME information.

[Ritesh]

Added for v5.2 in our TO-DO list.

[Author]

Posts