Using ssh to mysql_dump to local system?

[ChrisMacPherson]

Hi,

I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this?

I was thinking something like this:

- login to ssh
$mysql_admin database_name | local_pc (very simplified)

Any help would be appreciated.

Thanks.

Chris MacPherson

 

[DonQuichote]

Answered in MySQL forum. Do you run Linux on your desktop or just on the server? Putty is also available on Linux, by the way...

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)