Hello sir,
i have used this for taking the database backup
5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql.
but it creates a zero size database and in mail it gives error like command not found.
Please Help me
Hi,
Try to execute the command directly in shell to ensure that nothing is missing, and the path is correct
hello sir,
thanks for the reply but i am new to this and have no idea how to run shell directly and i have run those things in cronjobs .Please help me
5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql.
Threre are several problems with this crontab line.
1) The \ characters should be / characters. This is unix not MSDOS.
2) There is a trailing . character which is not required (delete it).
3) The cron will execute at 5 minutes past the hour every hour 7/24. Hope this is intentional? It will not execute at 05:00.