[useful] MySQL datbase backup script
Here is a script i use for backing my website up. Its a simple shell scipt that runs the mysql dump command.
-pdatabasepassword
databasename >$(date).sql
so a typical usage of this might be:
[code]
mysqldump -uroot -pajellydoghnut
database1 >$(date).sql
]/code]
Where root is the username, ajellydoughnut is
the password and database1 is the database i
want to backup.
The advantage to doing it this way is that i can
go ahead and add this script as a cron joob to be
executed say every Tuesday at 11am meaning
that my database is backed up automatically for
me and a backup of that database is downloaded
to wherever this script is stored in .sql format
(typically i put it in a folder of its own in my
home directory)
Another handy thing is that because
of >$(date).sql on the end the script automatically
sets the current date and time as the filename
meaning no more messing around looking
through the creation time, its just there in the
filename
Hope this helps someone.
-Lenswipe
Comments
-
#!/bin/sh
USER=root
PSW=PassWord
FN='/bin/date +%Y-%m-%d'
BK_DIR="/root/MySQL_BACKUP"
PARAM="--quote-names --add-drop-table -u$USER -p$PSW"
cd $BK_DIR
mysqldump ${PARAM} trac > trac.sql
mysqldump ${PARAM} zabbix > zabbix.sql
tar -cvf mysql_$(date +%d.%m.%y).tar *.sql
gzip mysql_$(date +%d.%m.%y).tar
chmod 600 ${BK_DIR}/mysql_$(date +%d.%m.%y).tar.gz0 -
is ther an adantage to doing it that way?0
-
yes. I guess portability is one big advantage with this last one. You can use it in another server just changing the variables. Also, its a complete script (#!/bin/sh....)0
Categories
- All Categories
- 50 LFX Mentorship
- 103 LFX Mentorship: Linux Kernel
- 553 Linux Foundation Boot Camps
- 296 Cloud Engineer Boot Camp
- 119 Advanced Cloud Engineer Boot Camp
- 52 DevOps Engineer Boot Camp
- 53 Cloud Native Developer Boot Camp
- 4 Express Training Courses
- 4 Express Courses - Discussion Forum
- 1.9K Training Courses
- 18 LFC110 Class Forum
- 6 LFC131 Class Forum
- 25 LFD102 Class Forum
- 150 LFD103 Class Forum
- 17 LFD121 Class Forum
- LFD137 Class Forum
- 61 LFD201 Class Forum
- LFD210 Class Forum
- LFD210-CN Class Forum
- 1 LFD213 Class Forum - Discontinued
- 128 LFD232 Class Forum
- LFD237 Class Forum
- 23 LFD254 Class Forum
- 598 LFD259 Class Forum
- 102 LFD272 Class Forum
- 1 LFD272-JP クラス フォーラム
- LFD273 Class Forum
- 2 LFS145 Class Forum
- 24 LFS200 Class Forum
- 739 LFS201 Class Forum
- 1 LFS201-JP クラス フォーラム
- 3 LFS203 Class Forum
- 69 LFS207 Class Forum
- 300 LFS211 Class Forum
- 54 LFS216 Class Forum
- 47 LFS241 Class Forum
- 41 LFS242 Class Forum
- 37 LFS243 Class Forum
- 11 LFS244 Class Forum
- 34 LFS250 Class Forum
- 1 LFS250-JP クラス フォーラム
- LFS251 Class Forum
- 140 LFS253 Class Forum
- LFS254 Class Forum
- 1K LFS258 Class Forum
- 10 LFS258-JP クラス フォーラム
- 92 LFS260 Class Forum
- 130 LFS261 Class Forum
- 32 LFS262 Class Forum
- 79 LFS263 Class Forum
- 15 LFS264 Class Forum
- 11 LFS266 Class Forum
- 17 LFS267 Class Forum
- 17 LFS268 Class Forum
- 23 LFS269 Class Forum
- 203 LFS272 Class Forum
- 1 LFS272-JP クラス フォーラム
- LFS281 Class Forum
- 221 LFW211 Class Forum
- 167 LFW212 Class Forum
- SKF100 Class Forum
- 902 Hardware
- 219 Drivers
- 74 I/O Devices
- 44 Monitors
- 115 Multimedia
- 209 Networking
- 101 Printers & Scanners
- 85 Storage
- 761 Linux Distributions
- 88 Debian
- 66 Fedora
- 15 Linux Mint
- 13 Mageia
- 24 openSUSE
- 141 Red Hat Enterprise
- 33 Slackware
- 13 SUSE Enterprise
- 356 Ubuntu
- 477 Linux System Administration
- 41 Cloud Computing
- 69 Command Line/Scripting
- Github systems admin projects
- 95 Linux Security
- 77 Network Management
- 108 System Management
- 49 Web Management
- 66 Mobile Computing
- 23 Android
- 29 Development
- 1.2K New to Linux
- 1.1K Getting Started with Linux
- 536 Off Topic
- 131 Introductions
- 216 Small Talk
- 21 Study Material
- 817 Programming and Development
- 275 Kernel Development
- 508 Software Development
- 928 Software
- 260 Applications
- 184 Command Line
- 3 Compiling/Installing
- 76 Games
- 316 Installation
- 59 All In Program
- 59 All In Forum
Upcoming Training
-
August 20, 2018
Kubernetes Administration (LFS458)
-
August 20, 2018
Linux System Administration (LFS301)
-
August 27, 2018
Open Source Virtualization (LFS462)
-
August 27, 2018
Linux Kernel Debugging and Security (LFD440)