18 - Maintenance

Sauvegarde

Base de données:

mysqldump -u root -p educapro > backup_$(date +%Y%m%d).sql

Fichiers:

tar -czf images_$(date +%Y%m%d).tar.gz public/images/exercices

Script automatique

#!/bin/bash
BACKUP_DIR="/var/backups/educapro"
mkdir -p $BACKUP_DIR
mysqldump -u root -p educapro | gzip > $BACKUP_DIR/db_$(date +%Y%m%d).sql.gz
find $BACKUP_DIR -mtime +7 -delete

Cron (2h du matin):

0 2 * * * /usr/local/bin/backup-educapro.sh

Monitoring

Logs:

tail -f storage/logs/laravel.log
tail -f /var/log/apache2/error.log

BDD:

SELECT table_name, ROUND((data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)'
FROM information_schema.TABLES 
WHERE table_schema = 'educapro';

Nettoyage:

php artisan queue:flush
> storage/logs/laravel.log
Admin > Logs > Supprimer > 90 jours