The easiest method to move a MonetDB to a new location, or to create a copy for back-up purposes, runs as follows. First stop the database server by calling the monetdb management tool
shell> monetdb lock demo
When the server is stopped, you can still connect as a database administrator
to ensure that all (update) queries have ceased execution
(see system monitor).
Once satisfied that the activity has ceased, you can either follow the safe
route to dump/restore
a database, or perform a file-level
RCP to copy the
complete dbfarm directory to another dbfarm location.
The MonetDB daemon process attached to the remote dbfarm will pick it up and
makes it visible for connections.
Finally, perform the following operation to continue processing user requests at
the orginal server.
shell> monetdb release demo