Joomla and WordPress are popular CMS software based on PHP/MySQL. Like any other website, Joomla or WordPress powered websites need regular backup – both the database and the template files.
Manual backing up the files (templates, modules, plugins, themes) require an FTP client like Filezilla. Read more on Filezilla FTP client.
Manual Joomla and WordPress database backup entails logging into your hosting account’s phpMyAdmin, click on the database that you want to back up, and click export, AND finally Go.
Automated backup of Joomla/ WordPress
Wordpress has a number of plugins that can help automate database backup by scheduling backs daily/weekly or monthly. Several plugins have the ability to email the database back up to your email address or save it in the Amazon cloud or your Dropbox account. Examples include WP-DB-Backup and WP Complete Backup (Backup the files and the WordPress database).
Joomla users can use Akeeba backup core to back up their website or even migrate their website to a new host. Akeeba core backup contain the database and files and has an installation script for easy restoration.