Backing up and restoring Joomla using Webmin
Last Updated on Friday, 17 July 2009 14:18 Written by Joe Aldeguer Saturday, 03 January 2009 01:00
Webmin also comes equipped with a powerful MySQL module which can be use to backup and restore a Joomla MySQL database.
Go to Servers | MySQL Database Server | Click on database being backup.Click Backup Database button. Choose location where to put backup /backup/name-of-database. Leave other backup options to use default setting unless you know exactly what you want set. Click Backup Now. As you can see from this page you could even set a scheduled backup!
When the backup runs it outputs the following message.
Restoring Joomla's MySQL database can be done using the same webmin module. Choose database to be restored, Click Execute SQL, Run SQL from file. Browse to location of your saved mysql database. Click Execute.
Webmin outputs restore process.
When you're done saving your database you could proceed with uploading the latest Joomla security patch using this guide.
If you use Virtualmin to manage your hosted website you're in luck. The backup and restore function does an excellent job of backing up a website root directory including the database being used. I have successfully used it to recover a damaged Joomla site.
Add this page to your favorite Social Bookmarking websites
Comments
I have an Ubuntu 9.04 SMP LAMP stack running webmin 1.470