Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- #----------------------------------------------------
- # a simple mysql database backup script.
- # version 2, updated March 26, 2011.
- # copyright 2011 alvin alexander, http://devdaily.com
- #----------------------------------------------------
- # This work is licensed under a Creative Commons
- # Attribution-ShareAlike 3.0 Unported License;
- # see http://creativecommons.org/licenses/by-sa/3.0/
- # for more information.
- #----------------------------------------------------
- # (1) set up all the mysqldump variables
- FILE=minime.sql.`date +"%Y%m%d"`
- DBSERVER=127.0.0.1
- DATABASE=REJESTRACJA
- USER=LOGOWANIE
- PASS=KdsuvY&82hdF@
- # (2) in case you run this more than once a day, remove the previous version of the file
- unalias rm 2> /dev/null
- rm ${FILE} 2> /dev/null
- rm ${FILE}.gz 2> /dev/null
- # (3) do the mysql database backup (dump)
- # use this command for a database server on a separate host:
- #mysqldump --opt --protocol=TCP --user=${USER} --password=${PASS} --host=${DBSERVER} ${DATABASE} > ${FILE}
- # use this command for a database server on localhost. add other options if need be.
- mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} > ${FILE}
- # (4) gzip the mysql database dump file
- gzip $FILE
- # (5) show the user the result
- echo "${FILE}.gz was created:"
- ls -l ${FILE}.gz
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement