Fli
05-24-2013, 11:10 PM
Hi, please how to make an .sh script which will make mysql backup with date and time stamp on file name?
Here i found something, but im unsure if its proper command:
$ mysqldump --add-drop-table --user=db_user --password='db_userpass' db_name > db_name-`date +%m-%d-%y`.sql
$ gzip db_name-x-x-x.sql
Do you know any good shell scripts, commands for this regular backup?
Here i found something, but im unsure if its proper command:
$ mysqldump --add-drop-table --user=db_user --password='db_userpass' db_name > db_name-`date +%m-%d-%y`.sql
$ gzip db_name-x-x-x.sql
Do you know any good shell scripts, commands for this regular backup?