MySQL dump from remote server to local windows box
I want to make a .sql copy on my local windows machine of some MySQL tables on a remote server. I can do this easily using phpMyAdmin (view dump schema & save as file) and end up with an .sql text file on my own harddrive (that way I have a text backup on my own computer of the table that I can restore if needed). What I want to do is figure out how to do this WITHOUT phpMyAdmin - but using SSH. I can SSH into the remote server no problem but I can't figure out the exact syntax for the mysqldump command. I have tried things like:
at the mysql> prompt ...
mysqldump -h localhost -u username -p password
databasename [tablename] > c:\sqlfiles\tablename.sql
but I get error - unknown command '/a'.
tried many other variations but can't seem to get it right.
Any help would be appreciated