coppermine-gallery.com/forum

No Support => Modifications/Add-Ons/Hacks => Mods: Miscellaneous => Topic started by: jpaffett on March 21, 2005, 04:25:20 PM

Title: Backup script
Post by: jpaffett on March 21, 2005, 04:25:20 PM
I've created a backup script to backup my Coppermine photo gallery to my local server. It handles backup of the online database and restoring the database to the local MySQL server and also backs up files from the remote albums/userpics directory to the local albums/userpics directory.

It's very hard coded at the moment, but if this would be useful to others, I'lll spend some time making it more flexible and user friendly.

Jeff
Title: Re: Backup script
Post by: Tranz on March 21, 2005, 06:25:20 PM
Sounds good. Doesn't seem like there has been one posted. Thanks.
Title: Re: [help wanted]:MySQL backup system
Post by: jpaffett on March 22, 2005, 04:52:24 PM
Coppermine Backup

This script is designed to provide a one-click backup solution
for your Coppermine Photo Gallery. It is aimed primarily at users
who have a small photo gallery, on the assumption that any owner
of a large gallery will probably have a general backup strategy
for their web server and database anyway.

I have tested this script on Mac OS X running Apache/PHP/Mysql
and Windows XP running Apache/PHP/MySQL.

NB: This script will drop your local Coppermine tables and
restore from the remote backup.

The following are assumed:

1) You have a working Coppermine install on your local system.

2) You have the MySQL client installed on your local system
(part of the standard MySQL install) and know where that resides
on your system.

3) You have remote access to your live MySQL database i.e. it can
be accessed via an IP address rather than just as localhost on
your live web server.

4) You have FTP access to your web site.

Installation:

backup.php should be installed in the main Coppermine directory of
your local system only.

backup.inc.php should be installed in the include directory of
your local Coppermine system only.

You need to go in to backup.inc.php and edit the variables as
instructed in the comments.

Running:

Simply call http://yourlocalsite/backup.php

When the script has run, it will display a log of the actions
completed.

I just posted a new version, which handles sub-directories other than userpics correctly. Also fixed a hard coding bug see posting below :o
Title: Re: Backup script
Post by: jpaffett on March 24, 2005, 02:55:05 PM
Here is the new version of the backup script, which handles sub-folders as well as userpics.

Jeff
Title: Re: Backup script
Post by: MatthewSchenker on June 25, 2007, 02:46:01 PM
Hello,
Just wanted to get an update on this modification.  It is definitely something I'd like to use.  Is it working well?
Thank you!
Title: Re: Backup script
Post by: Hein Traag on June 25, 2007, 03:26:21 PM
Why not download and install it and let us know the outcome  ;). Participate and help jpaffett improve his hack  :)
Title: Re: Backup script
Post by: MatthewSchenker on June 25, 2007, 03:41:47 PM
Hein,
I'd be willing to do this, and I think it's good to encourage and support people to try out modifications.

However, in past situations, when I've "experimented" I've been insulted by GauGau as being a "newbie" and not reading the documentation.
Title: Re: Backup script
Post by: Joachim Müller on July 04, 2007, 07:55:50 AM
Your reply was totally uncalled for. One-week-ban (limited to posting) for spreading this argument on yet another thread, cluttering it. Next ban will be permanent.