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: How to restore a specific album from backup  (Read 4313 times)

0 Members and 1 Guest are viewing this topic.

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
How to restore a specific album from backup
« on: December 09, 2005, 04:38:42 pm »

Sorry if this has been answered, please give me the link if so.

One of my users has deleted by accident one of his albums. I have backups of my entire site. How can I restore his album from the full backup? What should I do?

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: How to restore a specific album from backup
« Reply #1 on: December 10, 2005, 09:43:41 am »

I restored all the images from my backup. What should I do next to restore those images in the album now?

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: How to restore a specific album from backup
« Reply #2 on: December 10, 2005, 10:11:21 am »

there's no coppermine control for what you're trying to accomplish, you'll have to do this manually, using a third-party tool like phpMyAdmin that allows you to directly edit your database.
Logged

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: How to restore a specific album from backup
« Reply #3 on: December 10, 2005, 10:18:07 am »

there's no coppermine control for what you're trying to accomplish, you'll have to do this manually, using a third-party tool like phpMyAdmin that allows you to directly edit your database.

ok I have phpMyAdmin. What should I do there to get back those images in the user's gallery?

Nibbler

  • Guest
Re: How to restore a specific album from backup
« Reply #4 on: December 10, 2005, 12:28:39 pm »

Find your database backup sql file, look through it for the queries on the pics table for the user's pics and the albums table for the user's album and the comments if applicable. Then run those queries on your db. It's not a simple task and you should of course backup your db first.
Logged
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 19 queries.