incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charlie Andrews <charlieandrews....@gmail.com>
Subject Re: Table Creation Error
Date Mon, 02 Dec 2013 20:14:57 GMT
Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or is the keyspace
schema separate from the data it describes?

-Charlie

On Dec 2, 2013, at 3:10 PM, Robert Coli <rcoli@eventbrite.com> wrote:

> On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews <charlieandrews.cwa@gmail.com>
wrote:
> I am on version 2.0.2. Do you have any resources on how to dump and reload the schema?
> 
> I guess I should write a blog post on this guy, but the rough outline is :
> 
> 1) echo "DESCRIBE KEYSPACE <keyspace_name>;" | cqlsh > keyspace_name.schema.cqlsh
> 2) DROP KEYSPACE <keyspace_name>;
> 3) use the contents of keyspace_name.schema.cqlsh to re-create your schema
> 
> For step 3 you can probably do it en masse via another pipe through cqlsh, but I would
probably do it manually unless I had a huge amount of schema. You should probably keep a schema
dump in general, for recovery purposes.
> 
> =Rob
> PS - thx to devdazed for testing out the cqlsh syntax, I only use cassandra-cli in my
current deploys..


Mime
View raw message