sql dump scripts

sqldmp_windows.bat

powershell -noexit -executionpolicy bypass -File C:\wamp64\www\url\sqldmp_windows.ps1

sqldmp_windows.ps1

$date = Get-Date -format dd-MM-yyyy_HH-mm-ss

$db_name = "url"
$backup_path = "C:\wamp64\www\url\storage\sqlbackups"

$filename = "$($backup_path)\$($db_name)_$($date).sql"

C:\wamp64\bin\mysql\mysql5.7.14\bin\mysqldump.exe -u root -h 127.0.0.1 url > $filename

sqldump.sh

#!/bin/bash

db_name="DB_NAME"
user="ROOT"
pass="PASS"
backup_path="/var/www/kitapfil.com/sqldump"
date=$(date +"%d-%m-%Y_%H:%M:%S")

mysqldump -u $user -p$password $db_name | gzip > $backup_path/$db_name"_"$date.gz

chmod +x $backup_path/$db_name"_"$date.gz