coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: Dr_Michael on December 09, 2005, 04:38:42 PM

Title: How to restore a specific album from backup
Post by: Dr_Michael 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?
Title: Re: How to restore a specific album from backup
Post by: Dr_Michael 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?
Title: Re: How to restore a specific album from backup
Post by: Joachim Müller 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.
Title: Re: How to restore a specific album from backup
Post by: Dr_Michael on December 10, 2005, 10:18:07 AM
Quote from: GauGau 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.

ok I have phpMyAdmin. What should I do there to get back those images in the user's gallery?
Title: Re: How to restore a specific album from backup
Post by: Nibbler 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.