How to back up and restore data in Cassandra?

Backup data:

1. Connect to the Cassandra database using the command line tool cqlsh.
2. Use the command “COPY keyspace.table TO ‘backup.csv'” to export the data to a CSV file.
3. Copy or move this CSV file to a secure location as a backup.

Restore data:

1. Connect to the Cassandra database using the command line tool cqlsh.
2. Create a new empty table structure for importing backup data.
3. Use the command “COPY keyspace.table FROM ‘backup.csv'” to import backup data into a new table.
4. Ensure the successful import of data and verify the integrity of the data.