Results 1 to 9 of 9
Mar 24, 2002, 23:23 #1
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
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