Media Library Missing Items

  • Resolved Alexandre

    (@0xcafe-1)


    14 years, 6 months 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!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Alexandre

    (@0xcafe-1)

    14 years, 6 months 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!

    Thread Starter Alexandre

    (@0xcafe-1)

    14 years, 6 months 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)?

    Thread Starter Alexandre

    (@0xcafe-1)

    14 years, 6 months 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.

    Thread Starter Alexandre

    (@0xcafe-1)

    14 years, 6 months 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.

    😀

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Media Library Missing Items’ is closed to new replies.