Database Reference
In-Depth Information
7.
Once it completes, we can verify whether the data has been restored
by running the
select
command:
select * from twitter.users;
user_id | age | name
---------+-----+-------
ckbrown | 32 | chris
mevivs | 34 | vivek
Using nodetool refresh
Another way to restore the data is by using the
nodetool refresh
utility. It differs
from the
sstableloader
approach in that you need to manually copy
.db
files in
Cassandra data directory.
Figure 9-3
shows the structure of the copied sstables.
Figure 9-3
.
Copied sstables in the Cassandra data directory
Then run the
nodetool refresh
command:
vivek@vivek-Vostro-3560:~$ $CASSANDRA_HOME/bin/nodetool
refresh twitter users