Re: restoring lost data

2003-02-03 Thread David Cramblett
Peter, MySQL stores all updates that modify, insert or delete the database in a transaction log file, as long as the option is turned on, it is by default in some cases. The newer versions of MySQL use a binary log, often stored in the the data directory and named like "hostname".001, .002, e

RE: Restores using binary log

2003-02-02 Thread David Cramblett
Hello, I use MySQL in a production environment where it is running a few databases. I make hourly db backups using the perl hot copy script distributed with MySQL. I would like to be able to restore my db down to the minute with the binary log, but the options to the binary log parser are so