Is there a way to connect to the remote console, export SQLite data as .txt or csv and, download that into my local machine? I know there’s SCP but I don’t understand how it would work for my case. I thought about the steps below but haven’t reproduced them yet:
- ssh into the data volume through database_cli and export the data into a csv file
- Download the file using scp (However, in this step, what host should I use)?