note
gmax
<p>Recovery of a database could be as easy as running your latest backup and restart business, if you are well organized.</p>
<p>If you are using binary logs, the system can recover fairly easily. BLOBs are not a problem here, they are just more data in your database.</p>
<p>About organizing yourself, you might have noticed that I added a timestamp field to my table. This way, I can have a progressive backup of the fields that were modified in a given timeframe, to integrate with a full weekly backup.<br>
The subject deservers more space than we can dedicate here. The matter is explained much better than this in Paul Dubois' book, <a href="http://www.kitebird.com/mysql-book/">MySQL</a>.</p>
<p>Personally, I would say that storing blobs in sparse files makes your task more difficult, but TMTOWTDI, after all, and I might be wrong. Let's say that I am just more confortable with my current architecture.</p>
<pre>
_ _ _ _
(_|| | |(_|><
_|
</pre>
150255
150343