Title: lost database
Last modified: April 27, 2021

---

# lost database

 *  [MikeVS](https://wordpress.org/support/users/mikevs/)
 * (@mikevs)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/lost-database-3/)
 * Hello there,
    I recently updated to WP 5.7.1, as well as the latest version of
   WPPA (which I love by the way). I didn’t notice at first, but now none of my 
   galleries are showing up as they were before. When I looked inside, I noticed
   that there is now an old database file of my site that seems to have replaced
   a newer updated version (older version of galleries etc). I downloaded the most
   recent version of my database before updating. Do you know if I can simply, using
   php admin, import this slightly older version of my DB that I saved before updating,
   in order to restore my wppa galleries as before? The rest of the site works fine,
   but I lost all my previous galleries and their structures. When I use phpadmin
   to examine my current DB I see an older version that I used years ago. It’s strange.
   I’m glad I backed up my “current” working version just before updating, but I’m
   hesitant to just import it to see if it works! Thanks so much in advance for 
   your input!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Flost-database-3%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/)
 * (@opajaap)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/lost-database-3/#post-14373134)
 * Ypou should find in your backup the following db tables:
    **wppa_albums wppa_photos
   wppa_rating wppa_comments wppa_index wppa_iptc wppa_exif and replace the current
   with your backup. Then, run setup in Table VIII-A1 on the Photo ALbums -> Settings
   admin page
 *  Thread Starter [MikeVS](https://wordpress.org/support/users/mikevs/)
 * (@mikevs)
 * [5 years ago](https://wordpress.org/support/topic/lost-database-3/#post-14385449)
 * Thanks Jacob for your response. I understand what you are proposing. The problem
   is that I’m unable to open my backup sql file in order to export the correct 
   tables, so that I can then import them into the current (corrupt) db via myphpadmin.
   I’m on a mac, and I’ve been trying with various programs but I’m unable to open
   my sql backup file. A simple text editor can open it, but not in table format
   so the data is a mess. Any advice? Thanks so much.
 *  Thread Starter [MikeVS](https://wordpress.org/support/users/mikevs/)
 * (@mikevs)
 * [5 years ago](https://wordpress.org/support/topic/lost-database-3/#post-14385461)
 * To be clear about what I’m experiencing: when I click on a post, in the place
   of the gallery I am seeing just the shortcode. But what is more troubling is 
   that when I look at the parameters of my WPPA galleries, they are all my old 
   galleries that I have since updated 2 years ago. All the changes that I made 
   back then are lost. It’s very strange. So I have the backup db from when the 
   site was working correctly, but I’m unable to poke around inside to export the
   tables that you recommend.
 *  Thread Starter [MikeVS](https://wordpress.org/support/users/mikevs/)
 * (@mikevs)
 * [5 years ago](https://wordpress.org/support/topic/lost-database-3/#post-14385482)
 * More info: and, if I look in my media uploads folder, all of my up to date images
   are present. So it’s juste the WPPA parts of the database that seems to have 
   reverted. This may not be a WPPA issue, so I don’t want to bother you with tech
   support for the issue, but do you have any suggestions?
 *  Plugin Author [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/)
 * (@opajaap)
 * [5 years ago](https://wordpress.org/support/topic/lost-database-3/#post-14386820)
 * Maybe just install the backup of your entire db, and than update wp core again
   to fix the db version no of wp core on the dashboard -> Updates screen

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘lost database’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-photo-album-plus.svg)
 * [WP Photo Album Plus](https://wordpress.org/plugins/wp-photo-album-plus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-photo-album-plus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-photo-album-plus/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-photo-album-plus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-photo-album-plus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-photo-album-plus/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Jacob N. Breetvelt](https://wordpress.org/support/users/opajaap/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/lost-database-3/#post-14386820)
 * Status: not resolved