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

Reply via email to