Hi,
Which cron job's should be added for a good maintenance of RC?
gc.sh
and what else?
Thanks,
Hello,
sometimes I'm doing manuel:
$SQL = "SELECT * FROM contacts
WHERE del
= 1 AND
DATE_ADD(changed
,INTERVAL 45 DAY) < NOW() ";
$res = mysql_query($SQL) or die (__LINE__ .": ".$SQL);
while($row = mysql_fetch_array($res))
{
$SQL = "DELETE FROM contactgroupmembers
WHERE contact_id
=
".$row['contact_id'];
$rex = mysql_query($SQL) or die (__LINE__ .": ".$SQL);
$SQL = "DELETE FROM contacts
WHERE contact_id
= ".$row['contact_id'];
$rex = mysql_query($SQL) or die (__LINE__ .": ".$SQL);
echo "Delete ".$row['contact_id']."<br>";
flush();
}
mysql_free_result($res);
Best regards from germany
Ulli
From: users-bounces@lists.roundcube.net [mailto:users-bounces@lists.roundcube.net] On Behalf Of Jorge Bastos Sent: Thursday, December 07, 2017 11:43 AM To: 'Roundcube Users mailing list' users@lists.roundcube.net Subject: [RCU] Cron files
Hi,
Which cron job's should be added for a good maintenance of RC?
gc.sh
and what else?
Thanks,
On Thu, Dec 7, 2017 at 4:29 PM, Ulli Heist Ulli.Rainer.Heist@t-online.de wrote:
Hello,
sometimes I’m doing manuel:
$SQL = "SELECT * FROM
contacts
WHEREdel
= 1 AND DATE_ADD(changed
,INTERVAL 45 DAY) < NOW() ";...
We have bin/cleandb.sh
in Roundcube that does exactly this ;-)
This and the already mentioned bin/gc.sh
should do it for periodic clean-ups.
~Thomas
Hi Thomas,
Thank you, so i'll add gc and cleandb, whould this be running daily?
-----Original Message----- From: users-bounces@lists.roundcube.net [mailto:users-bounces@lists.roundcube.net] On Behalf Of Thomas Bruederli Sent: 10 de dezembro de 2017 14:56 To: Roundcube Users mailing list users@lists.roundcube.net Subject: Re: [RCU] Cron files
On Thu, Dec 7, 2017 at 4:29 PM, Ulli Heist Ulli.Rainer.Heist@t-online.de wrote:
Hello,
sometimes I'm doing manuel:
$SQL = "SELECT * FROM
contacts
WHEREdel
= 1 AND DATE_ADD(changed
,INTERVAL 45 DAY) < NOW() ";...
We have bin/cleandb.sh
in Roundcube that does exactly this ;-)
This and the already mentioned bin/gc.sh
should do it for periodic
clean-ups.
~Thomas _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users