View Single Post
  #10  
Old 05-14-2018, 08:34 AM
spidey1170
Sarnak
 
Join Date: May 2009
Location: Alaska
Posts: 61
Default

Awesome information, thank you. Going through it right now; I'm also working on creating a registration page, with an invite code (possibly), rather than having to enter the user & password manually.

May have found somebody to GM for me, a trusted friend of 18 years who I actually met playing EQ, funny enough 18 years ago.

Edit: Created shell script & cron job:

script:

Quote:
#!/bin/sh
# EQ DB Backup
EQDBBACK="[path_to_backup_folder]"
# Deletes files older than 7 days may be changed later
find $EQDBBACK -type f -mtime +7 -exec rm {} +
mysqldump --defaults-extra-file=$HOME/.my.cnf [db_name] > $EQDBBACK/$(date '+%Y%m%d_%H-%M-%S')_full_[db_name].sql
# compress the file
7z a $EQDBBACK/$(date '+%Y%m%d_%H-%M-%S')_full_eqemu.7z $EQDBBACK/*full*.sql
# Remove the SQL file
rm -rf $EQDBBACK/*full*.sql
$HOME/.my.cnf

Quote:
[mysqldump]
user=[db_username]
password=[super_secret_password]
crontab -e, will run twice daily every 12 hours

# minute hour day_of_month month day_of_week (sunday=0)
Quote:
0 */12 * * * [path_to_script]
Reply With Quote