-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathBackupDB.ps1
71 lines (52 loc) · 4.07 KB
/
BackupDB.ps1
1
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
#
# ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── I ──────────
# :::::: B A C K U P I N G W I T H P O W E R S H E L L A N D M Y S Q L D U M P : : : : : : : :
# ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
#
#
# ─── VARIABLES ──────────────────────────────────────────────────────────────────
#
$dbUser ="root"
$dbPassword ="exl@12345"
$dbHost ="localhost"
$dbName ="northwinddb"
#
# ─── DATE WITH FORMAT TO ADD A OUT SQL FILE ─────────────────────────────────────
#
$ACTUAL_DATE = Get-Date -Format "dd-MM-yyyy hh.mm.ss"
#
# ─── GETTING THE NAME OF THE OUT SQL FILE TO BACKUP ─────────────────────────────
#
$PATH_DBNAME_BAKUP ="C:\DBBackup"
$FILE_NAME_BACKUP_DBNAME ="DBNAMEdump_"
$FILE_BACKUP_DBNAME = $PATH_DBNAME_BAKUP+$FILE_NAME_BACKUP_DBNAME+$ACTUAL_DATE+".sql"
#
# ─── INVOKING THE COMPLETE COMMAND ──────────────────────────────────────────────
#
#
# ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── I ──────────
# :::::: B A C K U P I N G W I T H P O W E R S H E L L A N D M Y S Q L D U M P : : : : : : : :
# ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
#
#
# ─── VARIABLES ──────────────────────────────────────────────────────────────────
#
$dbUser ="root"
$dbPassword ="exl@12345"
$dbHost ="localhost"
$dbName ="Northwinddb"
#
# ─── DATE WITH FORMAT TO ADD A OUT SQL FILE ─────────────────────────────────────
#
$ACTUAL_DATE = Get-Date -Format "dd-MM-yyyy hh.mm.ss"
#
# ─── GETTING THE NAME OF THE OUT SQL FILE TO BACKUP ─────────────────────────────
#
$PATH_DBNAME_BAKUP ="C:\DBBackup\"
$FILE_NAME_BACKUP_DBNAME ="DBNAMEdump_"
$FILE_BACKUP_DBNAME = $PATH_DBNAME_BAKUP+$FILE_NAME_BACKUP_DBNAME+$ACTUAL_DATE+".sql"
echo $FILE_BACKUP_DBNAME
#
# ─── INVOKING THE COMPLETE COMMAND ──────────────────────────────────────────────
pushd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
.\mysqldump.exe --defaults-extra-file=mysql-credentials.cnf -h $dbHost $dbName > $FILE_BACKUP_DBNAME