How to restore a specific album from backup

[Dr_Michael]

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]

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

[Joachim Müller]

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.

[Dr_Michael]

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]

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.