Thanks for the comments Steve
I am using MySLQ 3.23.53 on XP. I can try the current version and see
what happens.
As an example, I can make a backup with mysqldump, flush the logs, return
to my app and add an item to the database that contains an attachment that
might be an mp3 or bmp stored
Rick,
I am able to restore from logs that had binary data (even though the
output looked real strange and messed up the terminal window). I did
have a problem once when I tried filtering data between mysqlbinlog and
mysql. Be careful if you do that.
What version of mysql are you using?
I have no
Hi,
I want to be able to use the MySQL binary logs and mysqlbinlog to restore
data if needed.
This works fine, except when the log contains sql that is written when I
save a binary stream to a BLOB column in a table. I will get one of those
messages like 'there is an error in your SQL at ...'