cronjobs which are scheduled in after update trigger.
I have the below script doing nightly backups of my databases. If I execute directly via shell, everything works. However, if via cron as same user execution, I get this error in the log file: nightly-backups.sh: 9: [[: not found 1 2 timestamp=`date +%Y-%m-%d`; 3 4 ##### EXECUTE THE MYSQL BACKUP ##### 5 echo "Starting … Read more
I have to update my MySQL database every hour, and I was wondering what the advantages/disadvantages of using a cronjob VS a MySQL event? For example, which is faster? Which is safer? Thanks!
I would like to purge my SQL database from all entires older than 1 week, and I’d like to do it nightly. So, I’m going to set up a cron job. How do I query mySQL without having to enter my password manually every time?
I tried many scripts for database backup but I couldn’t make it. I want to backup my database every hour.
I added files to “/etc/cron.hourly/” folder, changed its chmod to 755, but it didn’t run.
At least I write my pseudo code.
I would like to execute a procedure periodically, how to do that in MySQL?
I have a multi part question for a php script file. I am creating this file that updates the database every second. There is no other modeling method, it has to be done every second.
I have a file in mysite.com/url1/url2/cronjob.php which has to be run every minute. I try every combination, but can’t succeed. What should I run in command line? Thank you.
First, I created
.my.cnf in /home/username/ with the following text:
I am working on a CRON job that invokes a PHP script which does a lot of database work with loops.