Create Cleaner Job

The DB Cleaner Job is created on the Master Server. The server performs the database cleaning daily and deletes all files, depending on the settings, see Database Cleaning.

Just copy the following into the command line as root.

Note - since this command also uses the .my.cnf of the jtel user, the backup should be set up first.

cat << 'EOF' > /etc/cron.daily/db_cleaner.cron
#!/bin/bash
su - jtel -c 'bash /home/jtel/shared/JTELCarrierPortal/DB/mySQL/cleaners/db_cleaner.sh'
EOF

chmod 750 /etc/cron.daily/db_cleaner.cron
chmod 750 /home/jtel/shared/JTELCarrierPortal/DB/mySQL/cleaners/db_cleaner.sh
  • No labels