Title: alanman's Replies | WordPress.org

---

# alanman

  [  ](https://wordpress.org/support/users/alanman/)

 *   [Profile](https://wordpress.org/support/users/alanman/)
 *   [Topics Started](https://wordpress.org/support/users/alanman/topics/)
 *   [Replies Created](https://wordpress.org/support/users/alanman/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/alanman/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/alanman/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/alanman/engagements/)
 *   [Favorites](https://wordpress.org/support/users/alanman/favorites/)

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Reviews](https://wordpress.org/support/forum/reviews/)
    In reply to:
   [[Image Caption Hover] Everything is lost when plugins upgraded or move your site](https://wordpress.org/support/topic/everything-is-lost-when-plugins-upgraded-or-move-your-site/)
 *  [alanman](https://wordpress.org/support/users/alanman/)
 * (@alanman)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/everything-is-lost-when-plugins-upgraded-or-move-your-site/#post-10038086)
 * Hi,
 * I had a similar issue and managed to fix it. Here is what happened:
 * 1. We needed to migrate our site so took an dump of the DB.
    2. We did a find
   and replace on the MySQL dump file to replace the site URL. 3. When the site 
   was imported into the new WP instance all of the image hover galleries were empty.
   Each gallery was show in wp-admin, but no images were listed.
 * I spent some time looking at the wp_postmeta table ich_cpt rows. The meta_value
   rows store all of the image data. This data contains many fields. Each data item
   in the row contains a size value. When I updated the URL in the MySQL dump file
   I did not update the size of the URL field. This was the issue. Once I corrected
   the sizes the image hover wp_admin page was fixed and all the images returned.
   I just wrote an update statement to update the rows in my new DB.
 * Eg:
 * Before URL update
    s:44:”[http://localhost/wp-content/uploads/test.jpg&#8221](http://localhost/wp-content/uploads/test.jpg&#8221);
 * After URL update
    s:46:”[http://mynewdomain/wp-content/uploads/test.jpg&#8221](http://mynewdomain/wp-content/uploads/test.jpg&#8221);
 * Notice that the size is now 46. If you dont update the size the plugin will break.
 * Hope this helps you solve your issue.
    Alan

Viewing 1 replies (of 1 total)