To restore a backup file not listed here, follow these steps:

  1. Create the database by clicking "Create new database" in the Databases tab and create an internal database with the desired name.
  2. Run the mysql shell command as the root user:
    # bzcat var/backup/somedb/dump.sql.bz2 | mysql -urw -S mysql/socket somedb

mysql may be located in e.g. roxen/server-x.y.z/mysql/bin/mysql or /usr/local/lib/roxen-current/mysql/bin/mysql. mysql/socket may be located in e.g. roxen/configurations/_mysql/socket or /var/roxen/default/mysql/socket.

All database backups currently available: