Re: Creating a copy of a database -- best practice?

Author: Stephen Russell

Posted: 2019-02-28 at 06:08:31

Why not make a compressed file of the entire folder where the data lies?

After file is created move it to a different machine off the network.

On Thu, Feb 28, 2019 at 4:17 AM Alan Bourke <alanpbourke@fastmail.fm> wrote:

> Copy and rename all the data and database container files.

>

> For each DBF in the copied and renamed data, update the backlink so that

> it points at your copied and renamed DBC.

> Open the copied and renamed DBC as a table, and update the metadata

> describing the tables to reflect their new names.

>

> This is discussed here:

>

> http://www.ml-consult.co.uk/foxst-47.htm

>

>

> --

> Alan Bourke

> alanpbourke (at) fastmail (dot) fm

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJidMY+4Ekpeqrf0P4Z6U6PiXX7oGhYqkkDWypZ5PzB1w3Vczg@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2019 Stephen Russell