nur der Syntax für das Query ist mir ein Rätsel
... WHERE timestamp < (now() - INTERVAL 30 DAY)
DELETE LOW_PRIORITY FROM xxxxxx WHERE timestamp < (now() - INTERVAL 30 DAY);
mysql datenbankname -u username -ppasswort < tolledatei.sql
DELETE LOW_PRIORITY FROM xxxxxx WHERE timestamp < (now() - INTERVAL 30 DAY);
OPTIMIZE TABLE xxxxxxx;
mysql datenbankname -u username -ppasswort -e "DELETE LOW_PRIORITY FROM xxxxxx WHERE timestamp < (now() - INTERVAL 30 DAY); OPTIMIZE TABLE xxxxxxx;"
We use essential cookies to make this site work, and optional cookies to enhance your experience.