0
votes
1answer
29 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
0
votes
1answer
46 views

How do I monitor resource usage of crond php scripts?

I am using a VPS which is running 5 php scripts on a minute by minute basis using cron. Each script, itself, loops to execute a mysql query then sleeps for between 5 and 15 seconds. They all ...
3
votes
1answer
556 views

Shell script of mysqldump works fine when run manually, but does not run in the cron job?

I have a shell script to get a MySQL database dump. This script works fine when run manually #!/bin/sh fqn=/home/Mysqluser/daily_dumps/bookstore_`date +%Y%m%d_%H%M%S`.sql.gz mysqldump -u root -h ...