Skip to content

Instantly share code, notes, and snippets.

@nguyenthang98

nguyenthang98/dump_db.sh

Created May 3, 2021 03:58
Show Gist options
  • Save nguyenthang98/5088af50e754df2b5eb4711380b4f702 to your computer and use it in GitHub Desktop.
Save nguyenthang98/5088af50e754df2b5eb4711380b4f702 to your computer and use it in GitHub Desktop.
Download ZIP
cassandra
Raw
dump_db.sh
#!/bin/sh
# dump schema
cqlsh -u cassandra -p cassandra -e 'DESC KEYSPACE lwadb' >/scripts/schema_lwadb.cql
# dump data
cqlsh -k lwadb -u cassandra -p cassandra -e "COPY users to '/scripts/data_users.csv' with header=true"
Raw
import_db.sh
#!/bin/sh
# import schema
cqlsh -u cassandra -p cassandra -e "SOURCE '/scripts/schema_lwadb.cql'"
# dump data
cqlsh -k lwadb -u cassandra -p cassandra -e "COPY users from '/scripts/data_users.csv' with header=true"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment