Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Database Backup Question  (Read 2669 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.033 seconds with 16 queries.