There's a place for Backup and Migrate module in Drupal developers toolbox. In fact it should be in the top 10 modules to install when developing a site list. However there are situations where it's not the most efficient way to do things. I am lazy and I do forget to create backups. I could schedule them but that means I should have cron running regularly on my local copy which I normally don't. Here's where Navicat comes to the rescue. Full version of Navicat ships with extra goodies the lite version does not have. I'm especially fond of backup/restore functionality. When I'm working on a project I like to set up a backup schedule that creates backup files at regular intervals. There's pretty good documentation on it on Navicat site on backups and scheduling. The one thing that took me some time to figure out though was how to create db backups with timestamps. Turns out it's as simple as leaving "Use specified file name" unchecked in advanced settings for backup.

• admin's blog
• 
• print
• email