How to download a database with SSH access?

Question

MySQL

See if you can access files with SHH..
WP sites..
Need to transfer them to another hosting...
How can I download the database?
define('DB_HOST', 'localhost:');

Answer 1

Well, something like this (run locally):

ssh [email protected] "mysqldump -u USER -pPASSWORD DATABASE" >> local_dump.sql

Answer 2

Drag the /var/lib/mysql or /var/db/mysql directory, where all the databases actually lie. If, of course, there are enough rights.