Keyspace schema import and export in Cassandra

Question

I have a Cassandra 1.1.2 installation on my system as a single node cluster and have three keyspaces: `hotel`, `student` and `employee`. I want to dump the keyspace schema of `hotel` along with its column family data if possible and restore the dump on other Cassandra cluster. Can any one suggest me in detail that how should I do this?

Accepted Answer

You can use `sstable2json` and `json2sstable` cassandra tools Check out Datastax documentation on the same and this too ``` Usage: sstable2json [-f outfile] [-k key [-k key [...]]] Usage: json2sstable -K keyspace -c column_family ``` You can always execute cassandra-cli commands in file ``` cassandra-cli -h HOST -p PORT -f fileName ``` You can load all your create statements in to a file and execute this command To get cli scripts to create keyspaces and column families use following command in cassandra-cli interface ``` show schema ``` But incase you wanna create a cluster of two nodes. You don't need to do all the above. Just starting the other node with different token range and same cluster name would do. Cassandra internally will manage to stream the data and schema informations

Keyspace schema import and export in Cassandra

Solution

Problem