Scratchpad’s database is a simple log file like that:
2011-12-30T21:22:48-08:00
First post
^L
2011-12-31T01:42:24-08:00
Second post
^L
Just the time, and the content, and ^L –the ascii character 12 or form feed– as separator.
This gives me ‘super easy simple’ back-ups. On another server’s crontab I just add:
curl http://henry.precheur.org/scratchpad/log > backup/$(date)