On 2/9/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
On Fri, 9 Feb 2007, Mikey C wrote:
> This might be a dumb question, but is taking a backup of a live database
> simply a matter of copying the file to a backup device/drive?
Yes. It's a regular file to your OS. As a matter of fact, you can copy the
file to another name and open that other name to see the same tables and
data as with the original. That's how I keep a backup of the database I'm
developing.
You do, however, want to be sure there isn't a hot journal lying
around when you do the copy. Otherwise you could end up copying the
database file and not the journal, which effectively corrupts the
database.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
