Kurumunuzda veri kaybını önlemek için düzenli olarak veritabanı sunucularınızın yedeklenmesi çok önemlidir. Aşağıdaki powershell script’i ile MySQL veritabanlarınızı yedeklemek için kullanabilirsiniz.Aşağıdaki script dosyasını günlük olarak çalıştırmak için bir Task Scheduler ayarlayabilirsiniz.
|
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
################################################################## MysqlBackup.ps1# Author: Adrian# Updated:Oct. 2021## Description:# This script will query all MySQL databases and then create .sql backup files# of all located databases.##################################################################Set up your parameter$MYSQL_DIR = "C:\Program Files\MySQL\MySQL Server 5.6"$BACKUP_FOLDER = "C:\BT_MySQL_BACKUP"$dbuser = [your user]$dbpass = [your password]$BACKUPDATE = Get-Date -Format FileDate$EMAILFROM = [Your Email From]$EMAILRECIPIENT = [your email recipient]$SMTPServer = [SMTP SERVER]# Query and backup MySQL Databasestry { Set-Location "$MYSQL_DIR\bin" & .\mysql.exe -N -s -r -u $dbuser -p$dbpass -e 'show databases' | % { & .\mysqldump.exe -u $dbuser -p$dbpass --single-transaction $_ | Out-File "$BACKUP_FOLDER\${_}$BACKUPDATE.sql" -Encoding Ascii } Send-MailMessage -to $EMAILRECIPIENT -From $EMAILFROM -Subject "Backup MySQL Success" -Body "Backup MySQL Success" -SmtpServer $SMTPServer}catch{ Send-MailMessage -to $EMAILRECIPIENT -From $EMAILFROM -Subject "Backup MySQL Failed" -Body "Backup MySQL Failed" -SmtpServer $SMTPServer}# END OF SCRIPT |
