Thanks. I am running the jar, connecting to the database, and have looked at the Javadoc, but I am not sure what command to use to create the dump. When presented with the monetdb-> prompt is there a 'command line' way to create a dump, or is doDump() only available programmatically? ------------------------- Welcome to the MonetDB interactive JDBC terminal! Database: MonetDB v5.4.1, 'TESTDB' Driver: MonetDB Native Driver v1.7 (Canephora_p2 20080221 based on MCL v1.2) Type \q to quit, \h for a list of available commands auto commit mode: on monetdb-> \h Available commands: \q quits this program \h this help screen \d list available tables and views \d<obj> describes the given table or view \l<uri> executes the contents of the given file or URL \i<uri> batch executes the inserts from the given file or URL monetdb-> ---------------------------- On Monday 24 March 2008 04:35:27 Fabian Groffen wrote:
On 24-03-2008 01:01:14 -0400, McKennirey.Matthew wrote:
Forgot environment: built 2008-03-22 from nightly=stable on Linux (OpenSusue 10.2)
# MonetDB server v5.4.0, based on kernel v1.220 # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
The database dump command does not appear to support schemas
As workaround for the moment you could try the jdbcclient's dump feature, which does handle schemas, but fails to properly dump all constraints on tables. You can find jdbcclient here: http://homepages.cwi.nl/~fabian/troep/jdbcclient.jar