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

[noppid]

When logged in type "man chdir" without the quotes and hit enter. That's how you navigate.

I'm assuming linux. Windows is similar, but the paths for navigation use backslashes instead of forward slashes.

If you do it as is, the back up file should appear right where you are if you do an "ls". LS is the same as "dir" in dos.

To see more info, try "ls -al". To see how it works completely, "man ls".

Hope that helps. If you are starting from scratch, check out a simple linux how to.

[PhilipAlv]

Hi,thanks for the reply...yes...i use linux.....

i type in ls and find the backup.How do i save the file to my computer......by the way..is it possible to save it from my PuTTy client to my pc ?

I m new to all this stuff.My old admin left us without any notice and i m in the process of learning the stuff

[noppid]

You can push it via a CLI ftp command to another ftp server from ssh.

What ya need to do is backup to a folder you can access with ftp and grab it that way to download.

Say you have cpanel with a user named joeblow.

mysqldump --opt -Q -u dbusername -p databasename > /home/joeblow/backupname.sql

when done, joeblow hits ftp and the file is right there safe above public_html.

[snakes1100]

If you have a dedicated ftp backup with your host, you will need to setup a cron'd script and put it in the correct cron directory for nightly backup.

You will need ncftp or another like program to ftp the file to your backup as well.

If you have a ftp server running on your home server, you can also have the script ftp it over there as well.

Everything you want to do in your original post can be done with a script on a nightly basis.