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 <rc...@eventbrite.com> wrote: > 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..
