This is a simple module for full database Backup/Restore. I have been using it for all my apps for quite sometime now. It saves lot of time.
I have enabled basic access control so you can use it on live websites.
Yii 1.1 or above)
unzip the attached code under /protected/modules/
Add following code in config main.php under modules
You can specify custom path for backup files.
'backup'=> array('path' => __DIR__.'/../_backup/' ),
Thats it , now you can open your web app with ?r=backup or /backup appended to home url.