Problem with mySQL backup
I have read som posts about this topic but I can't make it work.
This is the code I try to use in myPHPadmin:
mysqldump -hlocalhost -uUSERNAME -pPASSWORD -nDATABASENAME >./backup/backup.sql
It don't work!! :( I want the file to be placed in the public_html/backup folder on my server.
I use Hostrocket as a host.
If I get this problem solved, how do I transfer the file to my hardisc?
Since there is both text and images in the database I was wondering if I should use a ASCII or Binary transfer.
I use a standard ftp program!
What should I do when I want to upload the file again using myPHPadmin? What code?