CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • good database backup script?
Pages: [1]

Author Topic: good database backup script?  (Read 3165 times)

webguy2

  • Guest
good database backup script?
December 10, 2008, 03:03:31 pm
I use Backup & Migrate for Drupal to cover my Drupal install but I see nothing for CiviCRM.  Any ideas for good scripts to automate the database backup?

Many thanks.

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: good database backup script?
December 11, 2008, 12:32:36 am
Quote from: webguy2 on December 10, 2008, 03:03:31 pm
I use Backup & Migrate for Drupal to cover my Drupal install but I see nothing for CiviCRM.  Any ideas for good scripts to automate the database backup?

We haven’t used any web-based backup solutions (we backup our databases on the server side, via commandline), so can’t really recommend anything. A quick googling turns up some example solutions for general, PHP-based MySQL backups.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

webguy2

  • Guest
Re: good database backup script?
April 13, 2009, 05:43:04 am
Yea, I've seen those but was hoping that Civi has come up with a mod like Drupal's "Backup and Migrate".

Thanks.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: good database backup script?
April 13, 2009, 10:24:25 am

wanna contribute a module to do this for civicrm? would be appreciated by other users? do ensure that you take care of FK dependencies and settings if you do step up :)

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

webguy2

  • Guest
Re: good database backup script?
April 13, 2009, 10:33:02 am
from a copyright perspective, can I simply modify the already existing "Backup and Migrate" module for Drupal?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: good database backup script?
April 13, 2009, 10:51:23 am

IANAL (i am not a lawyer) so take this post with that in mind :)

1. As long as you keep the GPL license and make sure you retain the license headers from the original script it should be fine

2. One big big difference is that Drupal does not use FK constraints and InnoDB as much as CiviCRM, so this might affect the scripts

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

webguy2

  • Guest
Re: good database backup script?
April 13, 2009, 11:07:02 am
thanks, I'll post if I am able to do it

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: good database backup script?
April 17, 2009, 01:26:25 pm
if you have access to the command lline
http://sourceforge.net/projects/automysqlbackup/
does daily, weekly and monthly
also rdiff-backup for a daily backup of your filesystem.

That is if you have command line access and a cron.

The script is well documented.
And you can do ALL or some of your databases.

webguy2

  • Guest
Re: good database backup script?
April 17, 2009, 01:33:48 pm
Thanks.  I actually already have a script that does all databases.  I was considering a module for civi that only did civi's db similar to drupal's "Backup and Migrate" module.

Thanks.

excell@drupal.org

  • Guest
Re: good database backup script?
May 04, 2009, 11:02:57 am
webguy - you should work with the module developer and help him test the work already done to incorporate civiCRM in the 2x dev

here is mention of this: http://drupal.org/node/275687 :)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • good database backup script?

This forum was archived on 2017-11-26.