Restore Backup to OpenACS DB

Upgrading and the upgrade failed? What do you do? If you're following the installation documents for Openacs, then you've got a backup of your database. Although recovery isn't exactly intuitive, you can do the following:

For Postgres, these are the steps to take to recover you database from backup.

1. dropdb dbname
2. createdb dbname
3. psql -f /var/web/your installation directory/packages/acs-kernel/sql/postgresql/postgresql.sql dbname (ignore errors) (note: your exact directory may be different!)
4. psql -f mydb.dmp dbname