Auto-Backup script for mysql in Unix

Question

I'm a Windows user but I've been asked to write a script that runs on Linux that does automatic backup for the MySQL database. I know how to do the backup (using mysqldump) but I don't know how to write a script in Linux and how to schedule it to run daily. How can it be done ?

David · Accepted Answer · 2010-07-28 16:33:05Z

2

Just a shell script? Bash should be easy enough for that:

http://www.gnu.org/software/bash/manual/bashref.html

http://tldp.org/LDP/abs/html/

As for the scheduling, you'll want to use cron:

http://en.wikipedia.org/wiki/Cron

answered Jul 28, 2010 at 16:33

David

221k42 gold badges245 silver badges337 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Auto-Backup script for mysql in Unix

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related