Given a non-compressed, text .sql file:
mysql -u user -p database_name < backup.sql
Be sure that the currently running mybb version is the same as what was running when the backup was created.
- Database passwords: forum/inc/config.php
Crash Prevention: Keep session table from crashing
Issue the following SQL command:
ALTER TABLE `mybb_sessions` ENGINE = memory
See the bottom of this page for using cron jobs for backups:
Note that for small boards, using the built-in task is sufficient.