On 5/16/07, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
On Wed, 16 May 2007, ik wrote: > On 5/16/07, Graeme Geldenhuys <[EMAIL PROTECTED]> wrote: > > What DBMS where you using? Firebird has no such issue. I store loads > > of PNG and JPG images in binary Blob fields. Backup and Restore works > > perfectly. > > I used Interbase 6.1. The problem was that gbak created a corrupted > backup file, that we could not restore, but we also saved the sql > dump, but we could not restore it... Hehe :-) ALWAYS test your backups. When backing up: immediatly restore to see if the backup is OK. Simpe rule, great benefits :-)
Oh, after I finished copy the backup the HD crashed, So you can see the problem ... :) Usually I'm the developer and not thr admin (unless i'm doing it as well to save time).
> > At my current work I'm working with MySQL clusters that the only way > to backup the data is by having sql dump. Unfortunately MySQL also generates "wrong" sql dumps at times. I learned that very quickly with the above rule...
Yes :( But I wrote a script that know how to fix that ... And that's why I use when possible non binary data... it's easier to restore from that.
Michael.
Ido -- http://ik.homelinux.org/ _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
