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