Re: [MonetDB-users] Database dump does not support schemas

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

 ./monetdb create TESTDB

 successfully created database 'TESTDB'

 ./monetdb start TESTDB

 ./mclient --database=TESTDB --user=monetdb --passwd=monetdb
 -lsql

 sql>CREATE SCHEMA abc;

 sql>CREATE TABLE abc.T1 (col1 VARCHAR (32));

 sql>CREATE TABLE abc.T2 (col1 VARCHAR (32));

 sql>\q;

 ./mclient -lsql --database=TESTDB --dump
 >/local/monetdb/test-dump.sql

 Table sys.t1 does not exist.

 Table sys.t2 does not exist.

 cat /local/monetdb/test-dump.sql

 START TRANSACTION;

 COMMIT;