Forum Backups Through SSH

[PhilipAlv]

Hi,i was going through this thread

I have a few doubts


When i login as root through PuTTy.this is the prompt i get "[root@secure ~]#"

So if i type in
"mysqldump --opt -Q -u dbusername -p databasename > backupname.sql" at the above prompt will it work ?..or should i get into another directory and run the command.

How do i change the prompt to another directory ?

Once i make the backup,how do i view the file ( how do i get to the location ) and how do i download it to my computer ?

Also,phpmyadmin says a particular database is 160 MB in size...but when i used the export option and save the very same database into my computer,the file size increased to 178 MB.Where did this extra 20 MB come from ?


Also,I have a 10 GB network backup space along with my hosting package.It can be accessed only via ftp once i log in as root through PuTTy.

How do i send the backups i take into that location ?



thanks