mysql backup

[elovkoff]

Considering the fact that shell script will be containing user credentials I think it is a good idea to put it in /usr/sbin - I think inly those with id 0 have access to this directory, right?
Thanks.

[trickster]

[quote author=elovkoff link=board=4;threadid=9557;start=0#msg87422 date=1091210036]
Considering the fact that shell script will be containing user credentials I think it is a good idea to put it in /usr/sbin - I think inly those with id 0 have access to this directory, right?
Thanks.
[/quote]
I'm not sure about that. I can look inisde sbin as I user (I think I can't execute...)

However, that 's not a problem. do a

chown myuser shellscript.sh

chmod 700 shellscript.sh

That way, only myuser can read, write or execute that file.
Then make sure is that user's cron that runs it.

[elovkoff]

Thanks everybody.

[Crouse]

Well..... I've been a lurking member long enough. So here is my first post.

Here is the backup script I use for my mysql databases.

----- Begin mysql_backup.sh --------------------------------------------

#!/bin/sh 
for i in `mysql -B -e "show databases" | tail +2`; do
mysqldump --opt $i | gzip -9 > /var/backups/mysql/$i.`date --iso-8601`.gz
ls -t /var/backups/mysql/$i.* | tail +7 | xargs rm -f
done

---- End Script -----------------------------------------------------------

This script keeps 8 days worth of compressed mysql backups in /var/backups/mysql . You can easily edit the script to change the number of days of backups you keep. I automate this in a cron job that runs nightly. Works great

[countach44]

That's a nifty script you got goin' on +1 karma.

[Crouse]

Woot......

Although I have NO idea what +1 karma means ??? Thanks.

[elovkoff]

Dummy question - how do I adjust the number of days in that script?

[Crouse]

Change the tail +7 to tail+WHATEVER

That should do it.

[elovkoff]

Thanks.

Karma it's a little number under your user icon which indicates that otehr users appreciated your replies