Hi all –

I have a monetdb instance with a lot of tables and a lot of data.  This data is organized into schemas.  While logging on today as the admistrator, I inadvertently typed:

sql>schema maizeFullGenome;

syntax error, unexpected SCHEMA in: "schema"

sql>

Instead of “set schema maizeFullGenome;”

This has apparently overwritten the data I had in my maizeFullGenome Schema.  Is there anyway to get this back besides finding an old copy of the db?  The following shows the schema as now gone:

sql>set schema maizeFullGenome;

operation successful

sql>\d

sql>

Yes, a very stupid mistake.

Lynn