How do I backup my database?

For a standard approach See this FAQ HERE

If you have Cpanel you might like to explore this further with Cron. This article is by John Seymour.

This Q&A was found on XOOPS Web Application System : https://xoops.org/modules/smartfaq/faq.php?faqid=84