think tank forum

general discussion » daily database backups

lucas's avatar
17 years ago
link
lucas
i ❤ demo
are working! :D

got a sweet little crontab:
45 0 * * * php bk.php


and bk.php:
http://www.wingedleopard.net/lucas/other/bk.phps

and here's what it looks like:
http://www.wingedleopard.net/lucas/other/gmail_ttfbackup.png

thanks, google! :o
lucas's avatar
17 years ago
link
lucas
i ❤ demo
in doing this project, i realized something: i didn't have an mta installed.

so every user that has registered since our move to this server hasn't been emailed a password.

:|
dannyp's avatar
17 years ago
link
dannyp
dʎuuɐp
Shit. Looks like JungleTarzan's going to have to wait.
lucas's avatar
17 years ago
link
lucas
i ❤ demo
or re-register...
lucas's avatar
17 years ago
link
lucas
i ❤ demo
i figure gmail can handle four backups per day...

lucas@wlw:~$ sudo crontab -u ttfbackup -l
15 */6 * * * php /home/ttfbackup/bk.php >/dev/null 2>&1
lucas@wlw:~$
DaGr8Gatzby's avatar
17 years ago
link
DaGr8Gatzby
Drunk by Myself
Run Postfix man.
lucas's avatar
17 years ago
link
lucas
i ❤ demo
i am.
lucas's avatar
17 years ago
link
lucas
i ❤ demo
with the bzip2 compression, the ttf database is only ~550KB! woo

i'm loving this automated backup thing. gmail better not lose my data...

:D
nny's avatar
17 years ago
link
nny
M̮͈̣̙̰̝̃̿̎̍ͬa͉̭̥͓ț̘ͯ̈́t̬̻͖̰̞͎ͤ̇ ̈̚J̹͎̿̾ȏ̞̫͈y̭̺ͭc̦̹̟̦̭̫͊̿ͩeͥ̌̾̓ͨ
yay whitespace
lucas's avatar
17 years ago
link
lucas
i ❤ demo
i don't know why i'm being nice to these guys:
http://forums.punbb.org/viewtopic.php?id=15561
lucas's avatar
11 years ago
r1, link
lucas
i ❤ demo
<ttfbackup@gmail.com>: host gmail-smtp-in.l.google.com[74.125.142.26] said:
    552-5.2.2 The email account that you tried to reach is over quota. Please
    direct 552-5.2.2 the recipient to 552 5.2.2
    http://support.google.com/mail/bin/answer.py?answer=6558 
bluet's avatar
11 years ago
link
bluet
LZMA to the rescue?