Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Backup Database Via Cron


i need to backup database,that not that much huge a small database,now iam useing cpanel server so iam takeing via phpmyadmin manually,now i need to set cron to take backup at every 12hours and save it on specified path,


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Simplest Way To Auto Cron A Mysql Database
I use a php script usually but that does not work for large files.

I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?

View Replies!   View Related
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 Replies!   View Related
How Can I Backup CPanel With Cron
I just went through a week of nightmares, because my host lost hard drives and stuff.. lost my data, etc.. what ever..

I want to work out how I can cron cPanel backups. I did a search online for a cPanel backup manager, but I didn't have much luck.

Or, maybe there's some other way to get regular backups?

I don't really need to backup my whole sites. I keep my files locally, but of course I don't have the databases locally -- or the email records.

All I "really" need is the database SQL files, so that I can rebuild my forums if need be, and also the email setup files -- because I have over 50 domains and I have emails set up on all of them.

I want to have them emailed to myself.

There's an option in cPanel too, which allows me to "generate/download a full backup".. well, how do I "restore" the backup? ie: I know how to backup and restore the home directory, databases and email stuff (there's 3 options in cPanel), but there doesn't seem to be anywhere to restore the full backup.

Anyway, can anyone give me advice on how to keep backups of my cPanel accounts? I don't trust hosts anymore. They say they back stuff up, but they never to.

View Replies!   View Related
Cpanel Cron Backup To Ftp
Im setting up new windows server, packed with only FTP server (FileZilla) to remote backups.

How can i get my cpanel account make backups and upload them to my FTP server as an cron job? Offcourse i have option to backup via cpanel, but this is needed to do manually every time (setting remote ftp ip, account, passwd etc,).

Is there a option in cpanel / whm to do full-backup all my accounts in my reseller account? Or do i need to do it per account? Some of my servers is only reseller accounts without root access, only reseller account.

View Replies!   View Related
Backup MySQL Databases By Cron
how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working.

Change the commented variables in the following file and save it as backup.sh:

Code:
#!/bin/sh

# This script will backup one or more mySQL databases
# and then optionally email them and/or FTP them

# This script will create a different backup file for each database by day of the week
# i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1)
# This is a trick so that you never have more than 7 days worth of backups on your FTP server.
# as the weeks rotate, the files from the same day of the prev week are overwritten.
#/bin/sh /home/user/directory/scriptname.sh > /dev/null
############################################################
#===> site-specific variables - customize for your site

# List all of the MySQL databases that you want to backup in here,
# each seperated by a space
# If not run by root, only one db per script instance
databases="mydbname"

# Directory where you want the backup files to be placed
backupdir=/home/mydomain/backups

# MySQL dump command, use the full path name here
mysqldumpcmd=/usr/bin/mysqldump

# MySQL Username and password
userpassword=" --user=myuser --password=mypasswd"

# MySQL dump options
dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

# Unix Commands
gzip=/bin/gzip
uuencode=/usr/bin/uuencode
mail=/bin/mail

# Send Backup? Would you like the backup emailed to you?
# Set to "y" if you do
sendbackup="n"
subject="mySQL Backup"
mailto="me@mydomain.com"

#===> site-specific variables for FTP
ftpbackup="y"
ftpserver="myftpserver.com"
ftpuser="myftpuser"
ftppasswd="myftppasswd"
# If you are keeping the backups in a subdir to your FTP root
ftpdir="forums"

#===> END site-specific variables - customize for your site
############################################################

# Get the Day of the Week (0-6)
# This allows to save one backup for each day of the week
# Just alter the date command if you want to use a timestamp
DOW=`date +%w`

# Create our backup directory if not already there
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ]
then
echo "Not a directory: ${backupdir}"
exit 1
fi

# Dump all of our databases
echo "Dumping MySQL Databases"
for database in $databases
do
$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql
done

# Compress all of our backup files
echo "Compressing Dump Files"
for database in $databases
do
rm -f ${backupdir}/${DOW}-${database}.sql.gz
$gzip ${backupdir}/${DOW}-${database}.sql
done

# Send the backups via email
if [ $sendbackup = "y" ]
then
for database in $databases
do
$uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu
$mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu
done
fi

# FTP it to the off-site server
echo "FTP file to $ftpserver FTP server"
if [ $ftpbackup = "y" ]
then
for database in $databases
do
echo "==> ${backupdir}/${DOW}-${database}.sql.gz"
ftp -n $ftpserver <<EOF
user $ftpuser $ftppasswd
bin
prompt
cd $ftpdir
lcd ${backupdir}
put ${DOW}-${database}.sql.gz
quit
EOF
done
fi

# And we're done
ls -l ${backupdir}
echo "Dump Complete!"
exit
Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone .

You should chmod the file to 777:

Code:
chmod 777 backup.sh
If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory:

Code:
dos2unix backup.sh
If you don't have dos2unix installed, you can install it using yum if you have that:

Code:
yum install dos2unix
If you don't have yum, get it here.

You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command:

Code:
./backup.sh
Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is:

Code:
/path/to/file/backup.sh

View Replies!   View Related
Cron Job To Send Backup Copy
Is it possible to get [Crone job] that sends a backup copy for single user in the server to another hosting via FTP which has [Domain name/ User /Password] either weekly or 3 times a week

View Replies!   View Related
Is It Possible To Create A Cron To Backup Mysql Data Daily
Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily

mysqldump -u usernam -p password dataname > file.sql

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
How To Backup Database (cpanel Server)
I have a crucial database (mysql).

My server is running cpanel. It has daily backup but it is not enough as it is running a lot of transaction daily.

I would like to run the backup to backup database only every 30 mins using cronjob. How do i do that in crontab. I have root access to the server.

View Replies!   View Related
Phpmyadmin Large Database Backup
I have a large database 800MB and the export zip & gzip option does not work on this size database export.

works fine on upto 30MB table sizes, does phpmyadmin not support large table
export/backup using gzip or zip?

If its the case that i should be able to use the zip options then what would i look for to put this problem right?

if its the case large table databases are not supported what could i use instead to backup the database tables with compression (gzip)?

View Replies!   View Related
Remote Database Backup Service
I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble.

I strongly prefer something simple and fully automated.

View Replies!   View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View Replies!   View Related
Backup Of MySQL Database To A Remote Server
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).

View Replies!   View Related
Backup For My Database To Move From Hostmonster But I Can’t
I just want to move from hostmonster to dedicated server

the problem is the database(vbulletin) size about 1 GB

when I try make backup for it through ssh it arraive to 723 MB then stop becuase it have highload on hostmonster system they not allowed more than 20% cpu

I take to them they tell me can’t do any thing I please them make backup but they say we can’t do any thing for you and I’m sure they can log by root and do it with ssh on less than 1 minute

how can I make backup or if there r way to move the database to the new server

2 day ago and I can’t move to the new server

View Replies!   View Related
What's The Easy Way To Backup Websites/mysql Database
Due to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.

Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?

View Replies!   View Related
Is CPanel Backup/database The Same As Phpmyadmin/export/.gz
Is the same type of file created through cPanel, going into backup then downloading the database backup as going through cPanel/phpmyadmin to export then saving the file as gzipped?

View Replies!   View Related
CPanel Automated Backup Is NOT Backuping One Big Database
i recently find out that I don;t have an database backup for one of my biggest websites.

The database I'm talking about has 228 tables (198.6 MB)

In the backup file I only get this :

-- MySQL dump 10.11
--
-- Host: localhost Database: lxxxxxxa_sXXXl
-- ------------------------------------------------------
-- Server version5.0.45-community-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

The other databases I have tried are all ok, but none is this big. Is there any size limit ?

I have uploaded an printscreen with the setings of my WHM.

View Replies!   View Related
Restoring SQL Database Backup To Invision Power Board
I moved my site to a new host and am running IPB 1.3 forums,

I have a 62meg sql backup to restore.

I have tried using BIGDUMP.php as max upload is over 52megs.
No Joy!

I also tried zipping the file, got it down to 9megs,

It wont complete the upload in PhpMyAdmin?

I have not had to restore a back up before, and am really struggling.

View Replies!   View Related
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
Rsyn --backup --backup-dir Switches For Incremental Backs
I current do some rsync backups with a command like so every day

rsync -az -e ssh --stats --delete --exclude "stuff" / user@server:/home/user/

What I want to do is have some incremental backups in there in subdirectories. So, for example, something like this on the remote server
/home/user/something.tuesday
/home/user/something.friday

I thought the --backup --backup-dir Switches were used to store just the files that had changed in seperate directories, am I wrong on that?

I've read everything I could find, including the big rsnapshot scripts, but I'm not able to do what I want, it seems so simple but something's not right, am I wrong that subdirs should have just files that are new or have changed. I tried various things like this, but had no luck

rsync -az -e ssh --stats --delete --backup --backup-dir=/home.Thursday --exclude "stuff" / user@server:/home/user/

View Replies!   View Related
How Transfer Full Backup From FTP Backup To CPanel?
I have transfer full backup with cpanel to ftp backup,

But,How transfer full backup from FTP Backup to cPanel?

Whitch software?

View Replies!   View Related
[cpbackup] Backup Failed! /backup Is Not Mounted!
my cpanel doesn't get backups. When I force it, it gives me this error:

mount: can't find /backup in /etc/fstab or /etc/mtab
mount: can't find /backup in /etc/fstab or /etc/mtab
[cpbackup] Backup failed! /bekkaplars is not mounted! at /scripts/cpbackup line 415.

It's a vps. Another interesting thing is, my other 3 vpses run good even /etc/fstab has no line like /backup in there, also.

View Replies!   View Related
Remote Backup Or Local Backup
I would like to weight the benefits and costs of using remote backup and local backup to another hardisk? Let's assume the price is the same.

What's the benefits of using remote backup?
Is it secured to use local backup in another hardisk?

I'm running on linux centos.

What happend if hacker get hold of my server?

Currently, i have 80GB of diskspace. Does it mean i will need at least 80GB of ANOTHER hardisk to backup that?

View Replies!   View Related
Cron
I have root access to a server. Is it possible to create a cron that would restart my ftp and http server every so often. Like once a week or somthing. If so how would i do it?

View Replies!   View Related
Per Second Cron Jobs?
Hey everyone, my friend's dad is looking for a web host that will allow his cron jobs to run every second. Most hosts apparently dont allow cron jobs faster than 5 seconds apart.

How often a host can run cron jobs isn't really advertised on their sites so I'm having a bit of trouble finding a host. I've resorted to just sending emails to sales addresses asking about it.

Does anyone know how I can find a host like this?

View Replies!   View Related
Cron: First Of The Month
Anyone know how I'd run a cron job on the begining (first day)of every month?

View Replies!   View Related
Does Cron Timeout?
Simply wondering, does cron timeout?

I have heard mixed reports and can't find any good info. Personally i've run a cronjob for up to 6 minutes, but as my best method was sending myself emails through php, its not exactly a highly accurate testing method.

On the same note, what would happen if one cronjob is running a php script for over 10 minutes, then another cron job starts on the same script, before the first one has finished?

View Replies!   View Related
Rsync And Cron
I have a bit of a strange problem, I have an rsync command setup in the servers crontab and from the cron log it show it ran the command but the files don't copy to the backup server. If I take the rsync syntax and run it manually all the files copy across with no errors, but I can't figure out why the cronjob doesn't work properly.

View Replies!   View Related
Remote Cron
I've just noticed that many people may have a free remote cron facility without realising it.

If you have any domains registered with Godaddy, you get free web space that includes a cron facility. It only runs every half hour, but you could set six jobs at 5 min intervals to get an effective 5-minute poll, which is good enough for many purposes. You could use it to check uptime on another site, for example. Has anyone tried this?

View Replies!   View Related
Cron Job
PHP Code:

* */1 * * *

But I didnt understand the difference from

PHP Code:

* * * * *

time property? Why is there a need for /1?

View Replies!   View Related
Cron Commands
I've been reading through tutorials for setting up cron commands via cPanel, but everything I have tried does not work. What I need to do is simple - I just want to run a php file on my server once every 15 minutes.

View Replies!   View Related
Error In Cron
Got this from the daily.cron email:

/etc/cron.daily/chkrootkit.sh:

/proc/18927/fd: No such file or directory

really weird, when I run that command manually, it doesn't show that error.

View Replies!   View Related
Cron Daemon
Im getting daily 100 of emails from Cron Daemon Cron

which having following information any body let me know what is cron daemon and how can i disable these email

Code:
/bin/sh: /usr/local/etc/logcheck.sh: No such file or directory

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 / WGet
My crontab uses Wget to access a PHP file. It works just fine; however, the only problem is that each time the crontab is run it creates a file in the root of my site called filename.php.10XX

filename is the name of the file that Wget runs and 10xx is just the number of times the tab has been run.

How can I prevent these files from being created?

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
How To Cron On Windows Server?
I truly love the 'cron' feature on Linux servers. This way I can schedule php scripts to do repetitive tasks on my website, but I plan to develop a asp.net website.

Is this kind of scheduling scripts possible on Windows servers? Else how do I perform repetitive automatic tasks? It would be a shared hosting.

View Replies!   View Related
Cron Job Every Month
I want to execute the following command on the 15th of every month at 1AM:

echo > /usr/local/apache/logs/error_log

How to accomplish this?

View Replies!   View Related
SSH Cron Job
I wanna run this command "./adfsas.sh" Every 4 Hours can someone tell me what command I can use via SSH to set this cronjob?

View Replies!   View Related
Cron Quit Working...
I have a dedicated CentOS 4.5 Server. However, as you can probably guess I am new to linux and managing a server...

Anyway, beginning of this month my crons quit working, I still receive emails as if they are ran but I can't get the scripts to actually execute.

I have not touched the crontabs or anything prior to them not working, they simply quit working... I did not notice immediatly they did not work, I am guessing that it was around the time of which I rebuilt apache to a new version of PHP. Today I tried changing them to "php path/to/script.php" and I also tried "path/to/php /path/to/script.php", neither worked.

Any ideas or suggestions as to how I can fix this?

View Replies!   View Related
MRTG Cron Error
I've installed mrtg on my server and it's working fine, but I keep getting the following cronjob error every few minutes:

/usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/lib64/libgd.so.2)

I've searched the net for a resolution and found others have had this issue, but no resolution has been offered.

Anyone else have this problem or know the solution?

View Replies!   View Related
Can Cron (back Ups)
I want to set up a cron job to make daily back-ups of my database, but by turning my site off first.

This is how I envisage it to work:
1: rename '.htacess' (in public_html folder for the site) to .htaccess-open
2: rename '.htaccess-closed' to .htaccess
// this closes the site down so no-one can write/access the db (they are basically shown a 'site down for maintenance' page - I already have the code for this)

3: mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > /path/to/dbbackup-$(date +%m%d%Y).sql
// this backs up the database

4: wait for 3 to finish
5: rename '.htaccess' to .htaccess-closed
6: rename '.htacess-open' to .htaccess
// this opens the site back upIs this easy enough to do? Anyone got any tips/pointers?

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
How Do I Change The Cron Schedule
We have a Cron executed program which runs at certain times of the day.
I need to changes these times.

How do I do this?

To be exact the program that is executed is called daily_charges.jsp

And I have looked under
etc/cron.daily
and I see no call to this program

FYI looking under etc/crontab I see this:

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

which obviously is the default Linux included Crontab file so this file cannot be the one that runs the daily crons.

how can I find where is the Cron code that daily runs the program:
daily_charges.jsp

View Replies!   View Related
How To Schedual Cron Jobs
I have a number of PHP scripts that I would like to automatically run daily at midnight. I am currently running a VPS server but have no idea how to achieve this. I do have webmin on my sever but am unsure of what command I need to run.

View Replies!   View Related
Cron Jobs Not Running
I have a machine, that for some reason stopped running it's cron jobs for some reason, and I can figure out how to get them working again.

My /etc/crontab file is as follows.

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly
Here are the contents of a sample user cron file.

MAILTO="USER"
10 4 * * * php -q -f /home/USER/public_html/tools/updtransfers.php /home/USER/public_html >/dev/null 2>&1
10 5 * * * php -q -f /home/USER/public_html/tools/updateexp.php /home/USER/public_html >/dev/null 2>&1
10 5 * * * php -q -f /home/USER/public_html/tools/invoice_cron.php /home/USER/public_html >/dev/null 2>&1
and another

*/5 * * * * /usr/local/bin/php -c /home/USER/php.ini /home/USER/public_html/poller.php > /dev/null 2>&1
I've checked my logs, and I can find no errors anywhere. When I run the commands manually via SSH, they work perfectly, they simply are not being run automatically the way they are supposed to be.

I have checked, and the crond service is running. I have tried restarting it, but it seams to have no affect. I really have no idea what the issue is. The only thing I seam to have found at one point, was the possibility that the files within the /etc/cron.d directory might be CHMOD'ed wrong, but I haven't found anything to confirm this either way.

[root@server cron.d]# ls -all
total 60
drwxr-xr-x 2 root root 4096 Dec 17 03:07 .
drwx--x--x 94 root root 12288 Jan 3 09:28 ..
-rw-r--r-- 1 root root 61 Jun 22 2007 csf_update
-rw-r--r-- 1 root root 81 Apr 11 2007 lsm
-rw-r--r-- 1 root root 79 Jun 22 2007 prm
-rw------- 1 root root 366 Feb 23 2007 sa-update
-rw-r--r-- 1 root root 82 Jun 22 2007 spri
-rw-r--r-- 1 root root 188 Nov 16 23:14 sysstat
[root@server cron.d]#

View Replies!   View Related
Cron Demon Error
I have got this email after a bit of tweaking of my server with this message for the last 6 hours at 2 hour intervals.

/etc/cron.hourly/modsecparse.pl:
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /etc/cron.hourly/modsecparse.pl line 19

View Replies!   View Related
Cron Job Less Than One Minitue
php script to run more than once per minitue.

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
Alternative To CRON As A Script
My webshosts don't offer CRONJOB's as standard. If I want to add it my hosting goes from £19.99 per annum to £89.99 would you believe!

Is there another way I can run scheduled jobs? Is there a PHP-script someone knows about?

Increasing my costs by 75% a year isn't feasable...

View Replies!   View Related
Cron- After SL Power Restored
One of our cronjob has to be executed at 23AM of each day. And it was programmed to be created file/folder name based on date value. I lost the 23AM of that day and no way to solve this problem.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved