Bruker:Mihho/db-backup.sh

<source lang=bash>

1. !/bin/bash

LISTA=`find /var/lib/mysql/ -maxdepth 1 -type d | awk -F '/' '{print $5}' | sort | uniq | sed '/^$/d'`

1. Find all databases, make the necessary mysqldump command, save it to a runme.sh file which can be run after

for i in $LISTA; do echo "cd /backup/helge; mysqldump --lock-tables=false $i > /backup/helge/$i.$(date +%Y-%m-%d:%T).sql"; done > /backup/helge/runme.sh echo "cd /backup/helge/; gzip *.sql" >> /backup/helge/runme.sh

1. make it runable

chmod 755 /backup/helge/runme.sh

1. Go backup!

/backup/helge/runme.sh

1. Save the commands in the runme.sh file to a local git repo?

cd /backup/helge/ git commit -m "runme.sh: db-backup kommandoene" runme.sh

exit; </source>