RE: Using mysqlbinlog to restore blob data

2003-02-20 Thread Rick Arthur
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

Using mysqlbinlog to restore blob data

2003-02-19 Thread Rick Arthur
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

RE: Using mysqlbinlog to restore blob data

2003-02-19 Thread Steven Roussey
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