How to export SQLite data into my local machine?

Questions / Help
1

Hi Team,

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:

  1. ssh into the data volume through database_cli and export the data into a csv file
  2. Download the file using scp (However, in this step, what host should I use)?

Thanks,

Gyo

2

Ok,
For now I resolved using the fly sftp command and downloaded the entire database file.
I think next time I can export the data into a csv file and download it the same way.

Thanks

Gyo

1 Like