Advanced

Backup all databases nightly w/ mysqldump automatically

Posted by kprojects on · 1 comment
LinuxForum.com; By Rob Kennedy 		Mail this story
Print this story

So, I want to take a shell script and be able to put it on any machine - and have it backup the databases on that machine using mysqldump.. and put them each separately into a backup directory.. here's what I came up with.

Can you make it better?

Full Story

  Nav
» Read more about: Groups: Linux, MySQL

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments (1)

vigeek ·
You should trap into a cleanup function in the event of an error.

DB Password should not be stored in clear text. Backups should not be done as the root user.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post