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:24:16 GMT
Just out of curiosity, what do you think occurred to cause this problem? I thought it was quite
strange that I didn’t get a useable error since my experience with this project has always
been pretty helpful errors.

Thanks,
Charlie

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

> On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews <charlieandrews.cwa@gmail.com>
wrote:
> Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or is the keyspace
schema separate from the data it describes?
> 
> Lol, sorry, yes. You will have to restore the data from the automatically created snapshot.
> 
> 1) echo "DESCRIBE KEYSPACE <keyspace_name>;" | cqlsh > keyspace_name.schema.cqlsh
> 2) DROP KEYSPACE <keyspace_name>;
> 3) restore keyspace's data from the snapshots created automatically when you DROP
> 4) use the contents of keyspace_name.schema.cqlsh to re-create your schema
> 5) rolling restart of all nodes (or use "nodetool refresh")
>  
> =Rob
> 


Mime
View raw message