How to dump a mysql database and download it locally to a computer?

Question

linux

via ssh I connect to the server ssh [email protected] -p номер_порта
there, stand is deployed lxc shell name_stand
on the stand, I do a dump mysqldump -u USERNAME DBNAME -p > /tmp/dump.sql
, now I would download it locally myself, can I do something? Or use another algorithm of actions?

Answer 1

lxc exec namestand -- mysqldump -u USERNAME DBNAME -p > /tmp/dump.sql
lxc file pull name_stand/tmp/dump.sql /path/to/your/local/dump/file.sql

And then via FTP from this server download the file /path/to/your/local/dump/file.sql

Answer 2

SCP download via shell

Answer 3

> /path from where you can download/dump.sql

Answer 4

mysqldump -uroot -ppass -P3386 dbname > dbname.sql
without spaces between the argument and value, and -p is the password port with a capital letter, you may also need a host other than localhost, look in the software settings for what is indicated there.
in more detail mysqldump --help
Also, you did not give data on what you have with your computer, maybe you have ftp there. or from this side of the site.
If the site is then you can simply pick up the file via a direct link.
or put phpmyadmin