I guess you have a lot of time and a lot of bandwith, and never worked from far away with limited access, limited time (15 minutes of connectivity only ?) and under a lot of pressure under production server.
I know all of this tools, and belive me that I know how to use them ! But sometimes the real way is to make backup using the most basic tools arrives with the database. But I guess you do not have experience with such things... Secondly, not all of the databases saves the blob the same way even on minor versions ! and sometimes it even modify the binary. I once had a sub version of a database that had a bug that added two bytes additional to binary blobs... when you read it with that version, everything worked, but when you moved to a newer/older version, it did not. There are many horrors with binary blobs. They are bad practice, and can cause many problems with your data ! But I guess you do not have experience with real life programming of binary blobs or working with databases... Otherwise you would have experienced with problems when using blobs... so please gain some experience in real life before jumping on things. On 5/15/07, Sergio Samayoa <[EMAIL PROTECTED]> wrote:
You must known your RBDMS or leave such task to DBA. For example: with Interbase / Firebird you can have more than one database file (a few years ago because file size constraints but now for device contention) and you should use gbak and new for FB nbackup instead of file copy. In Oracle, apart from IMP/EXP and new (for 10g) data pump, you can use RMAN and other database methods. I don't known much about postgres but I guess has nice backup utilities. If you are too lazy to learn how really your RDBMS works don't recommend bad practices. -----Mensaje original----- De: ik [mailto:[EMAIL PROTECTED] Enviado el: Martes, 15 de Mayo de 2007 10:47 a.m. Para: lazarus@miraclec.com Asunto: Re: [lazarus] Image from SQL On 5/15/07, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > Just use a decent backup, and not a generated sql-script. Amm.. that's what the backup mechanism does ! I'm talking about database grids, and some of the database engines. Unlike Interbase and mysql, that when you use them as a single database you can copy the files/directory, on many database engines and data grids, that's the only way that the database allows you to backup anything. _________________________________________________________________ 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
