Support Forums : DataStax

Cassandra Restore not working

(3 posts) (2 voices)

Tags:

No tags yet.

habeebraja
Member

Hi,

We had a cassandra cluster(DSE 2.1.1-1) with few nodes. We want to restore the data into new cassandra cluster(DSE 2.2.1).

The steps we followed below,

1. Took a snapshot from one of the node in existing cluster.
2. Brought up a new cluster with DSE 2.2.1
3. Just created a keyspace in the new cluster.
4. copied all the files from <snapshot>/<timestamp> to /var/lib/cassandra/data/<keyspace>/
5. started the cassandra service by using (dse cassandra)

But cant retrieve the data through cassandra-cli

We tried another option also.

1. Created keyspace and column families in the new cassandra cluster
2. restored the snapshot

This also not working.

The links we followed,
http://www.datastax.com/docs/1.1/operations/backup_restore
http://jonathanhui.com/cassandra-data-maintenance-backup-and-system-recovery

Is there anything we missed?

Thanks in advance.

Posted 6 months ago #
nickmbailey
Key Master

Cassandra uses the column family name in the path as well. Did you put the sstable files in the correct path?

var/lib/cassandra/data/<keyspace>/<column_family>/

Also, just to note, restoring a snapshot will not recreate the schema. You do need to create the same keyspace and column family names that you used on the old cluster.

Posted 6 months ago #
habeebraja
Member

Thanks Nick..

Posted 6 months ago #

You must log in to post.