#!/bin/bash
mysqldump -u<user> -p<password <web_db_name> > /path/to/file.sql
tar -pczf /path/to/backup/<name_of_archive>_$(date +%F).tar.gz /path/to/file.sql /path/to/site/www/ 
rm /path/to/file.sql
#EOF

@echo off
REM Keeps 1 week worth of database backups from server

REM Which day of the week is it?
SETLOCAL enabledelayedexpansion
SET /a count=0
FOR /F "skip=1" %%D IN ('wmic path win32_localtime get dayofweek') DO (
    if "!count!" GTR "0" GOTO next
    if %%D == 1 set dow=Monday
    if %%D == 2 set dow=Tuesday
    if %%D == 3 set dow=Wednesday
    if %%D == 4 set dow=Thursday
    if %%D == 5 set dow=Friday
    if %%D == 6 set dow=Saturday
    if %%D == 7 set dow=Sunday
    SET /a count+=1
)
:next

REM Delete backup from last week
FOR /D %%f in (*%dow%*) DO ( 
    rmdir %%f
)

REM Create directory with today's date and current time
set datetime=%dow%_%date:~-10,2%.%date:~-7,2%.%date:~-4,4%_%time:~0,2%.%time:~3,2%
md "C:\Users\me\Desktop\database_backups\backup_%datetime%"

REM Copy database backups directory to laptop
cd "C:\Users\me\Desktop"
pscp -r -batch -pw mypassword me@999.999.999.999:/backups/* C:\Users\me\Desktop\database_backups\backup_%datetime%