Automatic backup from SSH-server

Question

I am in needed of a script (. Bat) who log on to an SSH server, and perform a backup of my mysql database with the help of mysqldump.

This is to be run on a Windows computer and run three times per day.

I do not really know where I should start, but it ought to be finished examples on the net that I can use?

The requirements Log in to an ssh server Make a backup save the backup on my local machine This should be done three times per day

What software is needed? do you have any solutions I can work on?

The ultimate would have been one. Bat file somewhere on your computer that runs three times a day and do this without opening up a lot of programs.

Any help is appreciated

what platform is the mysql database running on? – uSlackr Aug 18 '12 at 21:23 — uSlackr, Aug 18 '12 at 21:23
Im not sure, but i think my webhost use Ubuntu Server – Tordbob Aug 18 '12 at 21:26 — Tordbob, Aug 18 '12 at 21:26

score 2 · Answer 1 · answered Aug 18 '12 at 20:01

2

Have a look at PuTTY: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Using a private SSH key (PuTTYgen), you should be able to connect to your server via SSH (PuTTYtel), run the backup and then pull the backup to your local PC (PSCP). Should be quite "automatable".

answered Aug 18 '12 at 20:01

PhilMasteG

121
2

This tutorial might help – uSlackr Aug 18 '12 at 21:32
Did you forget to attach a link? ;-) – PhilMasteG Aug 19 '12 at 01:38
http://www.howtoforge.com/ssh_key_based_logins_putty – uSlackr Aug 20 '12 at 12:04

Automatic backup from SSH-server

1 Answers1