Download db with SSH

I am into SSH for my server and i want to download databse.

ssh forge@**************

Now I am in mysql cli, and I choose db that I want to download.

mysql> use foo_db

What next?

Best Answer

Level 102

You can do it with one command

ssh forge@*** "mysqldump dbname -u username -p --single-transaction" > /path/to/local/file.sql

Level 14

@Sinnbeck -bash: /Users/foo/Downloads/foo.sql: No such file or directory

Level 102

@Ajvanho Weird. It works fine here. Maybe try ./foo.sql as path

Please or to participate in this conversation.