JoomlaPlug!

I've several demo sites and would like to reinstal my databases, let's say, every 2 hours. I thought I could do this with cron jobs, but it seems that I do not have enough rights on my server (shared server).

So this componant seems to be the good one for me, unfortunately I'm not a pro about php, so could someone help me to write a script to restore a db ?

Hi there! You have to check on your server first if JCron Sheduler works properly, and second if you are allowed to use mysqldump server utility, it would make things a lot easier!

So, first here what you would need to do:

1. create a file called cron.php and add in it this code

Code:

<?php echo shell_exec(&quot;mysqldump --help&quot;«»); ?>

2. upload the file on your server 3. Go in JCron cron management and add this file to the cron task, so when creating a cron choose as cron type "SSH command" and as for path try "php /home/.../path_to_cron.php/cron.php" 4. Make sure JCron runs by going in it's Configuration area and enabling it If all works ok, we can make a simple script based on mysqldump which you could use for backup and restore! Ovidiu

Thank you for this answer ..

I did what you said, and create a task to run every 10 mn ( */10 * * * *) but unfortunately I don't obtain logs or receive mail notifications, doesn't it mean that mysqldump is not available ?

EDIT : don't know if it's normal, but the check box near UNIX Crontab field put itself to off everytime I go back to the page !!<br><br>Post edited by: Epsylon, at: 2007/01/26 03:26

Could you post here 2 screenshots of your JCron configuration and the second of the edit page of the cron job!

Also, please attach here the php configuration of your site(phpinfo())!

When the cron it runs, at least the time of the &quot;Last time run&quot; field will change, did you notice that changing?

Ovidiu

<br><br>Post edited by: Epsylon, at: 2007/01/26 20:58

In fact, the last execution time changes if I check the unix crontab (and then it unchecks automatically )

Post edited by: Epsylon, at: 2007/01/26 07:00<br><br>Post edited by: Epsylon, at: 2007/01/26 20:58