I am having some trouble getting a command line mysqldump to work. Once a day I want to do a mysqldump of my database to a backup. Below is the command line, and I can't get it to work with or without passwords. Does anyone know why?
SHELL="/bin/bash"
35 1 * * 0 mysqldump -q my_forum_mysql_database -usite_user -pPASSwordhere > /backup/my_forum_backup_sunday.sql >/dev/null 2>&1
It is creating a file named my_forum_backup_sunday.sql with zero size.
SHELL="/bin/bash"
35 1 * * 0 mysqldump -q my_forum_mysql_database -usite_user -pPASSwordhere > /backup/my_forum_backup_sunday.sql >/dev/null 2>&1
It is creating a file named my_forum_backup_sunday.sql with zero size.