Hello, I’m trying to get a system in place for backing up and restoring a db through docker (cockroachdb version is v2.0.3). I was able to get the backup using cockroach dump (dump-mode=both), but can’t get it to restore. I’m using
docker exec [containerid] ./cockroach sql --insecure --database="db_new" < /path/to/backup.sql
(using db_new for testing, it is a blank database), but when I run it nothing happens and no error appears in the terminal. I heard updating db version could help, but this db is already live and I read updating the db version could cause issues with old data.
Thanks for your time, any help would be appreciated!