Since entire db backups have restore issues, I'm setting up separate shell scripts for each database. Use the following works well
mysqldump -u user -ppassword wishlist | gzip > /home/dbbackup/wishlist/wishlist_`date '+%m-%d-%Y'`.sql.gz
stored in /home/dbbackup
No comments:
Post a Comment