Hi. I have a dedicated server with a specialist application that is installed in the /home directory. It is probably quite large in the region of a couple of gig. I have root access via SSH. I have been using PUTTY and WINSCP to administer this server. My question is how do I make a backup of my home directory and the entire contents ? What are the commands for this using putty ? When I have the backup I will download it and store it offsite. Any help will be appreciated as this is urgently needed. Thank you
Just Login to the Putty and then fire the commands listed below one by one. cd / cd home tar -cvzf home.tar.gz . You can then download the file home.tar.gz using the FTP. Home directory backups can also be generated from the controlpanel.
Thank you very much. While it is backing up will it kill the server speed, should I wait until the early morning hours. How long would 2GB take to backup ? The server is dual core AMD opt 2GB Ram. At the moment it is very fast. Thank you. dalem
How about restoring the sql database using putty? I been trying to restore my database using winscp or putty, but I can't do with the command line. Perhaps I am doing the wrong command line.. What is the right command line in winscp or putty to restore my sql database which is at the root at my domain. Pls help.
Hi, You need to first create a dump of tthe database using mysqldump tool. After that you can take a backup of the resulting .sql file using http or ftp method, many of the techicians posted above. In case you want to backup all the databases, use the command. mysqldump --all-databases > all_databases.sql AFter that download/extract the all_databases.sql file to your local machine.