Skip to content
Magenaut

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

cron

How to abort Cronjob by name?

November 30, 2022 by Magenaut

I have cronjobs which are scheduled in after update trigger.

Categories Q&A, Salesforce Tags after-trigger, cron, job, jobid Leave a comment

Cron runs fine in shell, but fails when called by cron

November 29, 2022 by Magenaut

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

Categories MySQL, Q&A Tags bash, cron, mysql Leave a comment

Cronjob or MySQL event?

November 23, 2022 by Magenaut

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!

Categories MySQL, Q&A Tags cron, mysql, mysql-event Leave a comment

Run a mySQL query as a cron job?

November 23, 2022 by Magenaut

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?

Categories MySQL, Q&A Tags cron, mysql, php, shell Leave a comment

Linux shell script for database backup

November 21, 2022 by Magenaut

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.

Categories MySQL, Q&A Tags cron, linux, mysql, shell Leave a comment

Does MySQL have time-based triggers?

November 21, 2022 by Magenaut

I would like to execute a procedure periodically, how to do that in MySQL?

Categories MySQL, Q&A Tags cron, mysql, stored-procedures, triggers Leave a comment

PHP loop acting as cronjob[ensure only one instance running]

November 16, 2022 by Magenaut

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.

Categories MySQL, Q&A Tags centos, cron, mysql, php, ssh Leave a comment

Cronjob every minute

November 16, 2022 by Magenaut

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.

Categories MySQL, Q&A Tags cron, mysql, php Leave a comment

mysqldump is not working in cron

November 15, 2022 by Magenaut

First, I created .my.cnf in /home/username/ with the following text:

Categories MySQL, Q&A Tags cron, mysql, ubuntu Leave a comment

Generic “Killed” error in PHP script

November 15, 2022 by Magenaut

I am working on a CRON job that invokes a PHP script which does a lot of database work with loops.

Categories MySQL, Q&A Tags cron, mysql, php Leave a comment
Older posts
Page1 Page2 … Page16 Next →

Recent Comments

  • silverplugins217 on How to add placeholder for contact form7 for dropdown?
  • Shreyas Ikhar on How to add a custom CSS class to core blocks in Gutenberg editor?
  • Magenaut on How to call function on timer ASP.NET MVC
  • Ebaad Uddin on How to call function on timer ASP.NET MVC
  • michealSmith07 on Is there a way to dynamically refresh the less command?

Tags

.net adobe-illustrator adobe-photoshop ajax arrays asp.net asp.net-core asp.net-mvc bash c# css database django eloquent express html java javascript jquery json laravel laravel-4 laravel-5 laravel-8 linux list mongodb mongoose mysql node.js npm pandas php python python-3.x react-hooks react-native react-router reactjs redux regex sql string typescript wordpress
© 2023 Magenaut • Built with GeneratePress