Questions tagged [cron]

The tag has no usage guidance.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
237 views

Query to delete all rows which are not referenced in any other tables

Let's say i have a table called images. Images table is referenced in many other tables (movies, books, tv_series) through a foreign key. My question is if it is possible to write a query which will ...
1
vote
0answers
30 views

What's the best way to programatically have a MySQL DB update another MySQL DB

I am currently working for a service provider that offers Windows software for inventory control. This software connects to a MySQL DB on a dedicated server. So when this software is updated it ...
1
vote
1answer
835 views

Are certain environment variables required for mysql login-path?

I created a bash script that backs up my database, db_backup.sh It basically just runs these commands: DB=/home/linuxuser/backups/backupfilename.sql.gz mysqldump --login-path=local db_name | gzip &...
0
votes
0answers
12 views

Why cron jobs didn't be set correctly by Ansible playbook?

I created this playbook to set crontab: - name: Set PATH to crontab cron: name: PATH env: yes user: barman job: /usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/var/lib/...
0
votes
0answers
39 views

mysqldump writes dumped data to output

I'm trying to bring incremental backups to one old setup. The script I create worked perfectly when run directly. However when I run it from crontab or when redirecting shell output all data is ...
0
votes
0answers
68 views

MySQL pooled connections and crontab jobs (not reusing connections)

I have several cron jobs running and the task that cron has to do is execute a file that in turn checks and compares crawled data with data in the database, if it exists then the script ends and if it ...
0
votes
0answers
254 views

What is the best way to execute a MySQL script periodically on Linux

I want to execute some SQL everyday in a Linux server using MySQL to UPDATE some column's values. In order to do that I use the UPDATE ... SET ... WHERE ... statement. I want to know which is the ...
-3
votes
2answers
169 views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...