Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Database Backup Question  (Read 2719 times)

0 Members and 1 Guest are viewing this topic.

pzfc

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Database Backup Question
« on: August 30, 2005, 04:31:54 pm »

firstly i'm sorry for the constant questions. I'm really new to all this & need further help.

I did a backup of my gallery today following the instructions my hosting co gave me. I have nearly 1700 pics in my gallery.

http://www.preityzinta-fanclub.com/gallery

after i did the backup & downloaded the sql file. The size of the file was 435kb, my question is, is the size of the file meant to be that small? i was expecting it to be bigger.

am i doing something wrong? did i download the wrong file? please help.
Logged

steverobbins

  • Contributor
  • Coppermine novice
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 35
  • photographer
    • Steve Robbins' Personal Website
Re: Database Backup Question
« Reply #1 on: August 30, 2005, 04:46:38 pm »

Hi there,

Yes, that is an expected size of the database.  The database does not actually store the photographs, just information about them.  You can find your pictures and other files at /gallery/albums/userpics/*

You should back up this area as well for total peace of mind.

Regards
Steve.

pzfc

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Database Backup Question
« Reply #2 on: August 30, 2005, 05:56:36 pm »

awesome! thanks steve.

i do have a backup of the actual pics aswell so its all good for now.. ;D
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database Backup Question
« Reply #3 on: August 31, 2005, 09:07:34 am »

correction: the pics are actually located inside the albums folder, not limited to only the userpics subfolder. For an actual backup, you should have a local copy of your overall coppermine folder - it makes recovering from a server crash much easier.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 15 queries.