On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews <
charlieandrews....@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..

Reply via email to