The easiest and safest backup is just to go with:
- Database backup: do a mysqldump on the Joomla database
- Filesystem backup: on a backup folder do a cp -R on the web folder where Joomla is hosted
- Run a cron job to automate the above on a daily schedule
However not all web hosting providers will allow shell access to run a mysqldump or cron. The best thing to do is manually take database dump through phpMyAdmin "export" database function. The newer versions of phpMyAdmin are great for taking database backup even if your table has binary data.
phpMyAdmin -> Select database -> Click "Export" tab on top
Make sure you have,
- all tables selected
- structure and data checkbox on
- save as file checkbox on
Component
JoomlaPack
If phpMyadmin is also not available, then the next best alternative would be to install the Joomla extension JoomlaPack. JoomlaPack allows you to take a backup of your site files as well as database in a single zipped archive. You can then later use that archive to restore your site also using the JoomlaPack component. This can be great for moving sites from one host to the other which is often required when development and production sites are on different servers.
|