post deleted from sandbox, images disappear from working wordpress?

  • Please advise if the procedure I performed could have caused the problem I saw. I’ve got a sandbox copy of wordpress on the same system as the live/public wordpress, and I’ve been exporting from public and importing to the sandbox. As a result of refinements in the public wordpress, when I imported today, I got some duplicate postings. So, in the sandbox, I deleted a bunch of postings, and then imported once again. And didn’t look closely, but thought all was well in the sandbox. A few hours later, I get feedback that images are missing from the public wordpress. When I look at the results from the sandbox, I see that images point back to the original upload area.

    So, when I deleted a post containing an image(in the sandbox), did the image also get deleted (which was associated with the public version of wordpress?

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

  • Pretty much…

    Fyi: When you upload any attachment – be it an imag or spreadsheet file, etc…

    open up phpMyAdmin and look at the post_meta table.
    There you will find a bunch of records with a meta_key of: _wp_attached_file and a meta value containing an absolute path to the uploaded file on your server.

    If you uploaded a file from your live wordpress install, exported the live database and imported it into the sandbox wp install – logged into sandbox admin and deleted the attachment, you would be deleting the RECORD of the attachment from the sandbox and the actual file that is shared between both your wordpress installs. The record of the attachment would still exist in your live database – but the actual attachment file has been deleted.

    I really hope that made sense:)

    -Mike

    Thread Starter opinion8ted

    (@opinion8ted)

    Thanks – it does make sense, and the specific reference to the table involved clarifies it. But to be absolutely clear, I didn’t delete the uploaded file in the sandbox, I deleted the post (under manage/post), which deleted both the post, as expected, and the uploaded image in its original location, which was the surprise.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘post deleted from sandbox, images disappear from working wordpress?’ is closed to new replies.