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

C

CarfikDK2020-10-01 11:28:14

Is disclosing a user's IP legal? 4Reply

P

pfemidi2018-12-11 16:52:45

How to create progress bar like in Visual Studio Community installer? 2Reply

T

todoman2022-02-10 13:46:35

Excel: How to make autocomplete from duplicate but incrementing dates? 1Reply

G

gargamel12021-04-18 00:54:18

Working with multiple telebot keyboards? 1Reply

K

Kratko632020-10-15 12:48:58

How to make a MySQL SELECT query from 2 tables based on multiple values? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question