kstromeiraos/dump_restore_wasabi.md

## dump_restore_wasabi.md

      
    Raw
  

              dump_restore_wasabi.md
            
          
    Dump/restore Cassandra and MySQL data for Wasabi

If you have an existing installation of Wasabi on Docker containers and you want to save existing data, follow these steps.
Dump/restore Cassandra data

docker exec -ti wasabi-cassandra bash
apt update && apt install -y git python-pip && pip install cassandra-driver && git clone https://github.com/gianlucaborello/cassandradump && cd cassandradump && python cassandradump.py --keyspace wasabi_experiments --export-file wasabi_cassandra_dump.cql
exit

git clone https://github.com/gianlucaborello/cassandradump && cd cassandradump
docker cp wasabi-cassandra:/cassandradump/wasabi_cassandra_dump.cql $(pwd)
sudo apt install -y python-pip && pip install cassandra-driver
python cassandradump.py --host <cassandra_endpoint> --username cassandra --password 'sensitive' --import-file ./wasabi_cassandra_dump.cql --protocol-version 3

Dump/restore MySQL data

docker exec -it wasabi-mysql bash
# Default password is readwrite
mysqldump -u readwrite -p --databases wasabi > wasabi_mysql_dump.sql
exit

docker cp wasabi-mysql:/wasabi_mysql_dump.sql $(pwd)

vi wasabi_dump_db.sql
Replace lines containing definer=readwrite for definer=wasabi

mysql -u wasabi -p --host=<mysql_endpoint> < wasabi_mysql_dump.sql