incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Coli <rc...@eventbrite.com>
Subject Re: Table Creation Error
Date Mon, 02 Dec 2013 20:10:23 GMT
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