Anyone have experience with WinSCP for backups

Discussion in 'Site & Server Administration' started by HighRollerT, Jul 27, 2010.

  1. #1
    Im looking for an automated way top backup my blogs.

    Has anyone ever had experience with WinSCP
     
    HighRollerT, Jul 27, 2010 IP
  2. tolra

    tolra Active Member

    Messages:
    515
    Likes Received:
    36
    Best Answers:
    1
    Trophy Points:
    80
    #2
    Assuming your blog software uses a database you'll need to do this in 2 parts.

    1. On the server you will need to have a cron job which dumps the databases to a file so that you can download them. Personally I'd dump and compress the databases and also create a compressed archive of the files.

    You don't say what database you are using or what operating system your server is running so can't really point you in a direction there.

    2. Then on your PC you'll need to script a connect to your server and download which if you look at http://winscp.net/eng/docs/scripting shouldn't be too hard. Finally you need to set a task in task scheduler to run your script once a week or however often you need it.
     
    tolra, Jul 27, 2010 IP