I fixed the dump code to be aware of schemas. You can find it in tonight's nightly builds (if building succeeds, which it usually does). On 2008-03-24 06:01, 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
----------------------------
./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;
-------------------------------------------------------------------
-- Matthew McKennirey mmckennirey@dpfuture.biz home office 301 841 7690 cell 703 868 8234
------------------------------------------------------------------------
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender