Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


locked by HopelessN00b Jan 21 '15 at 11:18

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as off topic by EEAA, HopelessN00b, Magellan, John Gardeniers, MadHatter Nov 12 '12 at 15:17

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

what platform is the mysql database running on? – 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

Have a look at PuTTY:

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".

This tutorial might help – uSlackr Aug 18 '12 at 21:32
Did you forget to attach a link? ;-) – Philipp Grassl Aug 19 '12 at 1:38

Not the answer you're looking for? Browse other questions tagged or ask your own question.