Home » Groups » Philippines

Backing up drupal database

dreadstar's picture
Submitted by dreadstar on Thu, 2009-08-13 13:27

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?

Groups:
Philippines
Login to post comments

mysqldump

pedrochristopher - Thu, 2009-08-13 14:07

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.


Login to post comments