In cp.magnethosting.ie this can be done through PHPmyadmin, the database manager.
Once you have logged in here click on your database name in the top left hand corner.
When you have done this you should see your database tables in the main window. Next click on the “Export” option at the top of the page.
This will then open up a window with some options to select. Ensure that all of the tables are selected in the “Export” box.
Then select the “Save as file” option at the bottom of this page and click “Go” to the right of this to backup your database.
Note: This will only reliably backup a database up to about 10-15MB in size. For any database larger than that you will need to export the database via a cron job.