Posted by dreadstar on August 13, 2009 at 1:27pm
Question lang po sa mga webmasters,
What is your prefered way to backup your site's Drupal database? I started out with HeidiSQL but it became unstable exporting the database over 5MB large. I then switched over to using Phpmyadmin however noticed a restriction on the import stating max 10,240Kib (im assuming that means approx 10MB?). My backup is now over 9MB and approaching the 10MB mark. Will this pose a problem? If yes, what do people use to backup their drupal database?
Comments
mysqldump
Every hour I have a cron job that auto-backups all my CMS dbs, including my drupal dbs, kept locally as a tarball. Once a day they are also backuped up (with entire html directory) to a remote server, sftp through cron. I think it's over 100MB xfer, takes about an hour.