How to download a large database in CSV from a server via SSH?

J

J

jugger12020-09-02 20:41:39

MySQL

jugger1, 2020-09-02 20:41:39

How to download a large database in CSV from a server via SSH?

I tried to download via mysqldump, but there the file is downloaded in sql format and I don't know how to convert it to csv

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

P

planc, 2020-09-02
@jugger1

1) go to the server, archive the file:
gzip файл.csv
2) download using scp
scp ип_сервера:/путь/до/файла.csv.gz

Similar questions

P

Pempium42020-04-20 22:10:10

How to pass db record id from recyclerview to new fragment (client-server)? 0Reply

D

dieillusion2015-10-06 19:11:33

What DBMS do JAVA EE programmers use? 2Reply

A

alesto2011-04-22 22:23:12

I don’t know how to write a query in Mysql, I won’t describe it in the title. Look under the cut 4Reply

M

Maxim2011-04-24 11:36:44

Database (website) version control 9Reply

B

BudNejnee2021-06-16 13:55:55

MySQL 8 replication? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question