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: How to restore a specific album from backup  (Read 4068 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.014 seconds with 15 queries.