mysql_backup_locally
Differences
This shows you the differences between two versions of the page.
|
mysql_backup_locally [2009/05/02 07:11] k2patel created |
mysql_backup_locally [2020/08/10 02:35] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Mysql Backup Locally ====== | ||
| - | |||
| - | <code bash | mysqlbk.sh> | ||
| - | #!/bin/sh | ||
| - | |||
| - | DIR=<backup_directory> | ||
| - | PW=<root_password> | ||
| - | USER=<owner_of_file> | ||
| - | DATE=$(date +%Y%m%d) | ||
| - | |||
| - | mysqldump=$(which mysqldump) | ||
| - | mysql=$(which mysql) | ||
| - | tar=$(which tar) | ||
| - | chown=$(which chown) | ||
| - | |||
| - | for i in $($mysql -p$PW -e "SHOW DATABASES"|grep -v Database); do | ||
| - | $mysqldump -p$PW --allow-keywords $i > $DIR/$i.sql | ||
| - | done | ||
| - | |||
| - | cd $DIR | ||
| - | $tar -cvf $DATE.tar *.sql | ||
| - | rm $DIR/*.sql | ||
| - | $chown -R $USER $DIR | ||
| - | |||
| - | exit 0 | ||
| - | </code> | ||
mysql_backup_locally.txt ยท Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
