Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

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 professional 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

1 Answer 1

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

share|improve this answer
    
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.