Backup / Restore MySQL

MySQL-Backup Script
-------------------

#!/bin/bash

/path/to/mysqldump -u USER DBNAME > /path/to/backupdir/DBNAME.sql


z.B.

/usr/bin/mysqldump -u backup mysql > /var/www/backup/mysql.sql
/usr/bin/mysqldump -u backup joomla > /var/www/backup/joomla.sql




Mounten von Samba/Windows Shares
---------------------------------

/etc/samba/cred.txt
username=user
password=password


/etc/fstab

//SERVER/SHARE /media/MOUNTPONINT cifs credentials=/etc/samba/cred.txt 0 0


z.B:

//192.168.1.200/www /media/srv01 cifs credentials=/etc/samba/cred.txt 0 0





Datum und Uhrzeit in Variable schreiben
---------------------------------------


date +%Y%m%d-%H%M%S


FILEDATE=`date +%Y%m%d-%H%M%S`



z.B.

/usr/bin/mysqldump -u backup mysql > /var/www/backup/mysql-$FILEDATE.sql