WordPress.org

1. Alexandre Vallières-Lagacé
   Member
   Posted 3 years ago #
   

   Hi,

   I recently moved my blog to another host and thought I would start from a fresh WP install and do the export/import from the Tools section.

   Everything is smooth and running fine. I have all my wp-content/uploads stuff, but when I want to add an image that is in my library, I do a search but only the image I uploaded since the host change are available.

   I guess it did not export/import everything properly. Any idea where this data resides? I still have a mySQL export and local install of WAMP so I can load it there and extract whatever data I need.

   I just need to know where to look for it!
   Thanks!

2. Alexandre Vallières-Lagacé
   Member
   Posted 3 years ago #
   

   Anybody?

   I'm a developper so don't be afraid to tell me about MySQL queries to fix my situation. I'm pretty sure I'm missing something in some table, but I just can't see it!

   Thanks!

3. Alexandre Vallières-Lagacé
   Member
   Posted 3 years ago #
   

   I found that in wp_postmeta there is metakey with _wp_attached_file and _wp_attachment_metadata.

   Am I right in assuming that adding those to my new host will bring back all the media details to the library (given that the id is well managed)?

4. Alexandre Vallières-Lagacé
   Member
   Posted 3 years ago #
   

   I have imported those records succesfully (using auto increment for the ID) and it does not change anything... Is there something I have to do on the WP side to "commit" the changes? I have already commited the inserts and I can see them in phpMyAdmin.

5. Alexandre Vallières-Lagacé
   Member
   Posted 3 years ago #
   

   Ok, what I finally did was very simple, I only re-imported my XML export file with the media checkbox checked. All is fixed now.

   :D

Topic Closed

This topic has been closed to new replies.