My MySQL database backup (dump) shell script

#!/bin/sh

#----------------------------------------------------
# a simple mysql database backup script.
# version 2, updated March 26, 2011.
# copyright 2011 alvin alexander, <a title="http://devdaily.com" href="http://devdaily.com/">http://devdaily.com</a>
#----------------------------------------------------
# This work is licensed under a Creative Commons 
# Attribution-ShareAlike 3.0 Unported License;
# see <a title="http://creativecommons.org/licenses/by-sa/3.0/" href="http://creativecommons.org/licenses/by-sa/3.0/">http://creativecommons.org/licenses/by-sa/3.0/</a> 
# for more information.
#----------------------------------------------------

# (1) set up all the mysqldump variables
FILE=minime.sql.`date +"%Y%m%d"`
DBSERVER=127.0.0.1
DATABASE=XXX
USER=XXX
PASS=XXX

# (2) in case you run this more than once a day, remove the previous version of the file
unalias rm     2&gt; /dev/null
rm ${FILE}     2&gt; /dev/null
rm ${FILE}.gz  2&gt; /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} &gt; ${FILE}

# use this command for a database server on localhost. add other options if need be.
mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} &gt; ${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

#!/bin/sh

#----------------------------------------------------

# a simple mysql database backup script.

# version 2, updated March 26, 2011.

#----------------------------------------------------

# This work is licensed under a Creative Commons

# Attribution-ShareAlike 3.0 Unported License;

# see <a title="http://creativecommons.org/licenses/by-sa/3.0/" href="http://creativecommons.org/licenses/by-sa/3.0/">http://creativecommons.org/licenses/by-sa/3.0/</a>

# for more information.

#----------------------------------------------------

# (1) set up all the mysqldump variables

FILE=minime.sql.`date +"%Y%m%d"`

DBSERVER=127.0.0.1

DATABASE=XXX

USER=XXX

PASS=XXX

# (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