2015 m. lapkričio 10 d., antradienis

Mysql Backup via CMD / cron

Visu failu backup i viena faila sugzipinta, su datos reiksme
mysqldump -u username -pPASWORDAS --opt --all-databases | gzip >   DailyDB_`date '+%Y-%m-%d_%T'`.sql.gz

Arba skriptas - backupu darymas i atskirus failus pagal duombazes
#!/bin/bash

USER="dfdsf"
PASSWORD="sdfdsf"
OUTPUT="/path/to/dir/"

databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump -u $USER -p$PASSWORD --databases $db  | gzip > $OUTPUT/$db._`date '+%Y-%m-%d_%T'`.sql.gz
    fi
done
 you save the code in file backup.sh $ chmod +x