Hacker News new | ask | show | jobs
by yummyfajitas 5345 days ago
Restoring is another 6 lines of bash:

    s3cmd --config ~/.s3cfg get s3://BUCKET/database_$1.sql.gz
    gunzip database_$1.sql.gz
    sudo -u postgres dropdb DBNAME
    sudo -u postgres createdb -O DBUSER DBNAME
    sudo -u postgres psql DBNAME < database_$1.sql
    rm database_$1.sql
But I suppose being database agnostic would be handy - it would make switching from mysql to postgres easier.