How Set Up Cron Job Auto Empty A Tables Of A Database
How to set up cron job auto empty a table of an database at specify time.
OS: Centos 5 64 bit , Cpanel: cPanel 11.24.4-R32486 - WHM 11.24.2 - X 3.9
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
How To Merge A Database Into A New Empty Database
How to merge a database into a new empty database? I used this method and its not working mysqldump --opt -uusername -p databasename > databasename.sql mysqldump --opt -uusername -p databasename < databasename.sql but get this error /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
View Replies!
View Related
Cron Job
in order to backup db automatically i want to use cron job. So i set cron job at 00 AM suppose that : my infos db name : db db user : zode db pass : 123 the command i use is following PHP Code: mysqldump -u zode -p123 of -K -c -f --compatible=mysql40 --default-character-set=utf8 db > backup/db_`date +%d%m%y`.sql in good time i am looking into backup directory db is in it or not but there is nothing in it
View Replies!
View Related
Cron Job
I run A Centos 4.xx latest kernel server and Ive got a problem with Cron Job reporting. The Cron Jobs themselves are working fine but I keep getting this message, on the hour, every hour Quote: Originally Posted by Email from the Cron Daemon Not a directory: /etc/cron.hourly The folder etc/cron.hourly DOES EXIST! and I cannot work out what could be causing this? Does anyone hgave any ideas what could be causing it
View Replies!
View Related
CRON Job Timing Out
i have had a problem for some time now, regarding my CRON jobs. I am trying to download a large amount of data from ebay (through their API, totally legal and aboveboard) using php, but my CRONjob times out. I have tried resetting the timeout variable, but then it exceeds the maximum filesize SO, my question: is there any way to have a script run as a CRON job, and wen it is complete, call another script?
View Replies!
View Related
Reboot Cron Job
VPS isn't rebooting by itself when it goes down. Anyone has any program/script that monitors heartbeat of the server? Like when it goes down, the program will automatically reboots the system. I know there's such a script out there but I forgot what it called.
View Replies!
View Related
Cron Job Email In DA
I've got limited knowledge in scripting so I've come to the interweb for help. Google hasn't answered any of my queries so the trusty WHT is next. I'm trying to create a script cron that will email my clients once per month with space and bandwidth useage reminders. I'd prefer not to have to set up crons in each individual account, but rather email all with tokening including |name| |bandwidth| |space| out of the allowed space & bandwidth according to the clients package.
View Replies!
View Related
MySQLDUMP Cron Job
setting up a new cron job. I would like to have MySQLDUMP dump my specified database(s) into a specified folder using date and time stamps in the filename. I've done some searching on this but haven't really came up with a way to do all of this at once, or if I may need to setup a cron job to rename the file after the dump has completed. I may be going about this all wrong to begin with, I'm just looking for a very simple and reliable way to backup my databases. I'm testing this on a Shared Web Host account at this time which does have SSH shell access, but I wasn't sure if this makes a difference.
View Replies!
View Related
Cron Job Deleted - Is Their A Log?
We are running cpanel on one of our servers. Several cron jobs were deleted from the cron panel of one acct. I have no idea of the paths to re-enter these jobs. Is their a log file on the server that will show cron job history from previous runs so I can recover the proper paths?
View Replies!
View Related
Cron Job And Query String
Is it possible to call a cron job with a query string appended to the file. I have no problem setting up crons in the cron tab..but i'd like the cron to fetch a url that looks something like /home/php/some-file.php?a=1 is this possible directly through the cron job? I guess an alternative is call some php file that uses curl but i was wondering if there 's a direct way.
View Replies!
View Related
Random Cron Job Command
I am running wordpress with wp O matic. I want to update my content after 24 hours (but different time each day). Bottom line is I want a cron command which randomly execute after 24 hours instead of a particular time. For example currently wp o matic shows the following command the following command, would you please advice how i change the this command to achieve the above results (right now wordpress is running on my computer so following thing is just for example) */20 * * * * F:Testlogwp-contentpluginswp-o-matic/cron.php?code=8b935355
View Replies!
View Related
Cron Job Not Working Properly
I have a slight problem with a cron job I have setup. I wanted to save a copy of iptables every hour to a folder, so I created a script... here it is: Code: varDate=`date +%y%m%d` varTime=`date +%H%M` filename="IPtablesBackup-$varDate-$varTime" iptables-save -c > /etc/IPtablesBackup/$filename and called is Backup-Script.sh Now if I just execute the script will in root ./Backup-Script.sh I get a new file with the correct filename and iptables info is saved ! Great ! So then I thought, how can I setup this automatically every hour. Which leads me on to my problem. I inputted "crontab -e" added this line Code: 59 * * * * /etc/IPtablesBackup/Backup-Script.sh The problem is the script is run, I know because it creates a new file with the correct time and date, however the file is empty? I have set Backup-Script.sh to 777 and owner and group are both root?
View Replies!
View Related
Cron Job With Multiple Databases
I have several DBs and need to run a cron job on one of the databases every night. to run a repair/optimize on the DB as its very active, this is the command I thought I would use: Code: REPAIR TABLE `etc` , `etc` , Code: OPTIMIZE TABLE `etc` , `etc` , How do I specify which database to run this on in the cron in CPanel?
View Replies!
View Related
Cron Job Failure Mails
I have a server like this: WHM 10.8.0 cPanel 10.9.0-S9966 CentOS 3.8 i686 - WHM X v3.1.0 My cron files are like this: var/spool/cron/ Quote: 33 4 * * * /scripts/upcp 0 1 * * * /scripts/cpbackup */15 * * * * /usr/local/cpanel/whostmgr/bin/dnsqueue > /dev/null 2>&1 2,58 * * * * /usr/local/bandmin/bandmin 24 5 * * * /usr/local/cpanel/whostmgr/docroot/cgi/cpaddons_report.pl --notify 0 0 * * * /usr/local/bandmin/ipaddrmap 0 */1 * * * /usr/local/nobody_check/nobody_check >/dev/null 2>&1 0 6 * * * /scripts/exim_tidydb > /dev/null 2>&1 */5 * * * * perl /root/rvadmin/rvmultiupdate.pl >/dev/null 2>&1 14 6 * * * perl /root/rvadmin/auto_rvskin.pl */5 * * * * /usr/local/cpanel/bin/dcpumon >/dev/null 2>&1 But e-mails like tha is coming to me Quote: Cron <root@mavi> /usr/local/cpanel/bin/dcpumon >/dev/null 2>&1 /bin/sh: line 1: 1 : ambiguous redirect Quote: Cron <root@mavi> perl /root/rvadmin/rvmultiupdate.pl >/dev/null 2>&1 /bin/sh: line 1: 1 : ambiguous redirect
View Replies!
View Related
Cron Job Not Working, Restart Services
I'm having a bit of trouble with one cron job that doesn't seem to work. I have others scripts that run hourly fine. However this one does not. The script: restart_monitoring.sh Code: #!/bin/bash service iptables stop service iptables start /root/bandwidth_rules.sh /root/portforward_config.sh exit The two scripts at the end just load a lot of iptables rules back in. The cron job should run hourly (59th minute) The cron job entry Code: 59 * * * * /root/restart_monitoring.sh I have restart crond to enable the new job, still doesn't run. The job is to restart iptables, thus flushing all rules that I have running, then reloading them. I have figured out the problem to be with the "service iptables stop/start" command, it doesn't seem to like doing this...?
View Replies!
View Related
Cron Job In Cpanel. Want To Automate Backups
I have been doing some research and I would love some help with this. I want to set up a cron to automatically backup my site's files & databases once a month. And I am not sure what how I do it? - Do I need a script on my server and then the cron job runs it? - Is there a better way to do this then cron?
View Replies!
View Related
Auto Restart Apache On Cron
ive got a fairly beefy server but at the moment its hosting alot of resource intensive sites (unfortunatly i dont currently have a choice on where to run them all) and apache is crashing to the point its taking upto 2 mins to load pages within about 24hours but once restarted is fine again. so im wondering if anyone can suggest a way to automaticly restart apache via a cron job every 24hours or so?
View Replies!
View Related
Cron Job :: Run Script Every Second, Of Every Minute, Of Every Day
Say I have a script... /home/user/public_html/script.php I want to run this script every second, of every minute, of every day. How would I do this? I want to set up a cron and run it, I have written a cron and I am running it in shell as I type, but if I close shell the cron exits, can anybody assist me with making a cron run this script every second permanently.
View Replies!
View Related
Scheduled Consecutive Shell Commands Or As Cron Job
Is it possible to schedule consecutive shell commands to be run at a given time or every certain period (like every hour)? This is important for me as I want to schedule to run certain program and then input the following commands afterwards to do and complete the task, all automatically within the specified schedule. One example would be connecting to an FTP. First you'd need to input the ftp command to run the ftp program, then following that, input another commands consecutively within that session (the ftp program) to do and complete the task. I'm running KDE on CentOs4 btw. Is it even possible to do this on cron jobs?
View Replies!
View Related
Cron Job That Deletes Backup Files Older Than 5 Days
This is on a RHEL 4 Box. I want to create a cron job that deletes backup files that are older than 5 days. I have created a shell script (/usr/local/src/runjob.sh) that runs successfully from the SSH command line: Code: #pwd /usr/local/src #./runjob.sh Here is the script: Code: #!/bin/sh # # find /usr/local/apache/sites/*/BACKUPS/ -maxdepth 1 -atime +5 -iname 'test*.txt' -exec rm {} ; Script has 777 permissions and is owned by root. I have the following entry in crontab: Code: 10 12 * * * /bin/sh /usr/local/src/runjob.sh >/dev/null 2>&1 As shown in the cron log, the job does run, but it does not delete the files. And there are files older than 5 days in the directory that meet the find criteria.
View Replies!
View Related
Create A Cron Job To Clear Your /tmp Folder Automatically?
how I can create a cron job that runs every 10minutes or so to clear my /tmp folder on one of my servers? Reason I ask is, it keeps getting filled up and doesn't delete the fiels in it and stops certain scripts from running. Also, again, I need step by step instructions, such as: 1) what, where the file is I need to place the cron job in 2) what line of code would I put in that file (what does the cron job line look like for every 10min every day) 3) do I need to restart anything, and if so, what command do I run in shell?
View Replies!
View Related
HOWTO Cron Job To Copy Files From Folder To Root
how to setup a cron job to copy files & directories from one folder to the root folder. I have CPanel X. My root directory is public_html/ I have another directory public_html/uploads containing both files and directories. I need a cron job that will copy all the files & directories from public_html/uploads to the root public_html/ If it helps, here is some system info General server information: Operating system Linux Service Status Click to View Kernel version 2.6.22_hg_grsec_pax Apache version 1.3.39 (Unix) PERL version 5.8.8 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.22-standard cPanel Build 11.17.0-STABLE 19434 Theme cPanel X v2.6.0
View Replies!
View Related
Cron Job - "No Input File Specified."
I'm on paid hosting and accessing the cron jobs through a control panel. I have a php script that I'd like to run daily. I've put this script in the folder http://mysite.com/Cron/ . When I navigate to this file directly in my web-browser it runs perfectly and sends me an e-mail. When I try to set up a cron tab to execute it, though I get the following error in the cron output... Quote: Status: 404 X-Powered-By: PHP/4.4.6 Content-type: text/html No input file specified. The command I entered into the control panel was... Quote: php [url] I also tried... Quote: php -q [url] ...and... Quote: php /Cron/SendMail.php ...those times getting the error... Quote: /bin/sh: [url]: No such file or directory why this might not be working for me?
View Replies!
View Related
MySQL Doubt: More DB's & Less Tables || More Tables Less DB's
im planning on designing a webservice, it will have a lot of data, spread in many tables. The problem is that there will be tables created constantly (around 5 each day..) All tables/data will be accessed equally, so I dont know how to set up the system, to create multiple databases, and balance the number of tables equally on each database, or create less databases and have a lot of tables on each one. Which one has more efficiency?
View Replies!
View Related
Do Exchange Auto-responders Reply To Auto-responders
I have an address that receives hundreds and hundreds of e-mails a day. It's an address people aren't supposed to use (basically noreply@mydomain.com), but people do. I'd like to stop being the guy that gets these and routes them as appropriate, but we can't just turn it off and cause a hard bounce, because that will bewilder too many people who don't get that replying to noreply@mydomain.com is a bad idea. (Our website sends out notifications to people. A lot of people reply for various strange reasons, and we also get a lot of autoresponders sending us junk.) I'm a Linux admin, so I'm a bit out of my league -- this needs to be configured on our Exchange box. What I'd really like is an auto-responder for this address that will tell people that they e-mailed a mailbox that no one uses, and give them directions on how to contact a real person if need be. However, fully half of the e-mails we receive are people's auto-responders. Is an Exchange auto-responder going to reply to their auto-responder? This will completely bewilder people. And if this will auto-respond to auto-responders, is there a cleaner solution here? Again, it's got to be Exchange, but I'm a Postfix guy, so I have very little experience here.
View Replies!
View Related
Empty Reply From Server
I'm having some problems with my script, i think its not really a script error... - Script connects to rapidshare to send a file to the user - Rapidshare allows unlimited parallel connections, so no problem - Though some of the time (not alot), i get a connection error. - Connection error is: Empty reply from server - Strange thing is, i get this when i do a curl connection to rapidshare - ping, telnet, fsockopen, all is working, but it seems that i don't get a reply from the server Well, is this a problem on my side or on the rapidshare servers? Also, is there a problem to fix this? Server is using: - curl 7.15.5 - php 5.21 - apache 2.2.3 there's no firewall setup on my site..., also i can't find anything in iptables,...
View Replies!
View Related
Empty Box Hosting
I'm setting up a PHP shop website and the script that I'm going to be using has a pretty heavy list of requirements. Instead of looking for hosting software packages, I was wondering that are there any hosts that offer an "empty box" where clients can install all the needed software (apache, php, mysql, etc...)? If not, then what would be the best host for getting a custom PHP build (I'm looking for PHP 5.20).
View Replies!
View Related
Munin Graphs Are Empty
Munin was running OK on my cPanel server until yesterday when the graphs stopped updating themselves. I attempted a "/usr/share/munin/munin-update --force-root" which did nothing. Then I uninstalled and reinstalled munin on the cPanel plugins screen and now its running but all the graphs are empty
View Replies!
View Related
CSF Enabled But Iptables Empty
/etc/init.d/iptables status Table: mangle Table: filter Table: nat /sbin/iptables -v -I INPUT -s 1.1.1.1 -j DROP no "response" .. this means the iptables are simply empty I guess! CSF is enabled and working, at least it's sending me mails that it's blocking IP's or if CPU load is too high. /etc/init.d/iptables status is working but not saving anything My current iptables: Code: # Generated by iptables-save v1.2.11 on Tue Feb 19 08:30:06 2008 *mangle :PREROUTING ACCEPT [11582:3937365] :INPUT ACCEPT [11582:3937365] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [11881:5171405] :POSTROUTING ACCEPT [11881:5171405] COMMIT # Completed on Tue Feb 19 08:30:06 2008 # Generated by iptables-save v1.2.11 on Tue Feb 19 08:30:06 2008 *filter :INPUT ACCEPT [11582:3937365] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [11881:5171405] COMMIT # Completed on Tue Feb 19 08:30:06 2008 # Generated by iptables-save v1.2.11 on Tue Feb 19 08:30:06 2008 *nat :PREROUTING ACCEPT [1203:62871] :POSTROUTING ACCEPT [257:16291] :OUTPUT ACCEPT [257:16291] COMMIT # Completed on Tue Feb 19 08:30:06 2008
View Replies!
View Related
Dropping Empty UDP Packets
I currently have my own dedicated server located with the following prefs; Linux: CentOS 4.6 (final) Kernel Version: 2.6.9-67.0.15.ELsmp I know this is possible, but I am seeking how to drop empty udp packets automatically with iptables.
View Replies!
View Related
Possible To Ban Users With Empty IP Addresses
Some bot(s) without a reported IP address seems to be making 60 - 500 connections to my server constantly even though there are usually only a few real users connected. Does some search engines/some legit proxy users have no reported/hidden IP address? Am I even able to ban an empty IP with iptables?
View Replies!
View Related
|
TRACKER
