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...
At my current work I'm working with MySQL clusters that the only way
to backup the data is by having sql dump.
At my current work all of the servers does not belong to my company
but to a client, so we require to give a very fast diagnostic for any
problem (sometimes without direct access at all) and to solve it. I
found out that it's easier to fix database that stores images using
base64 text blobs then binary.
Graeme.
Ido
On 5/15/07, ik <[EMAIL PROTECTED]> wrote:
> Many of the database backup and restore tools backup the data as sql dump.
> The binary image can not be restored "as-is" in that sql dump.
> I had a problem once that an hardrive collapse, and when I tried to
> restore the sql dump, it was unable to restore it because of that. So
> since then I learned from expirence :)
>
> Ido
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
--
http://ik.homelinux.org/
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
