I want to take a backup of a database and redirect the output of the whole process to a log file. I am using the below command:
mysqldump -A --add-drop-table > mysql-daily-backup.sql &> /tmp/backup_log/mysql.log
Is there anything wrong with the syntax?
---------- Post updated at 08:32 PM ---------- Previous update was at 08:32 PM ----------
Detected the error.
This will create an empty file called mysql-daily-backup.sql and the full SQL dump will go to /tmp/backup_log/mysql.log. So i modified it to:
(mysqldump �v -A --add-drop-table > mysql-daily-backup.sql) &> /tmp/backup_log/mysql.log
Serves my purpose now.