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)