simple file mover by jenz
general compression: XZ_OPT='-T3 --memlimit-compress=70%' tar -cJf ovh_backup_2023.tar.xz /home/gameservers/
general decompression: tar -xJf file.pkg.tar.xz
virtualenv venv
source venv/bin/activate
pip3 install -r requirements.txt
config file: server specifics
requires an ~/.my.cnf with
[mysqldump]
host=""
user=""
password=""
python3 file_mover.py config.json
systemctl enable file_mover.timer
systemctl start file_mover.timer
logging: journalctl -f -u file_mover.service
logging: systemctl status file_mover.service
self reminder for pulling a schema out of the sql backup file.: awk '/^-- Current Database: unloze_forum_2|^CREATE DATABASE .*unloze_forum_2|^USE unloze_forum_2;/ {p=1; print; next} /^CREATE DATABASE/ || /^USE / {p=0} p' mysqldump.sql > unloze_forum_2.sql
