Return to previous page

Cant find pictures attached to the blog Posts in MyPhpAdmin

This topic has 2 replies, 2 voices, and was last updated 8 months ago ago by Luca Rossi

Papuna

Participant

March 18, 2024 at 12:01

Hello,

Could you tell me where is pictures attached to the blog post in MyPHPadmin?

I found that all the blog posts are at the table wpi6_posts with post_type value “post”.

but I do not see where are pictures attached to the posts.

kind regards,

Papuna

#387337 Copied Theme version: 9.2.8

1 Answer

Luca Rossi

Support staff

March 18, 2024 at 15:56

Hello Papuna,

Thank you for reaching out to us with your query regarding the location of pictures attached to blog posts in MyPHPadmin.

The images you are looking for are typically stored in the WordPress Media Library, and their corresponding records are also located in the wpi6_posts table, but with the post_type value set to “attachment”. These attachments are associated with posts through the wpi6_postmeta table.

To find the images attached to a specific post, you can look for entries in the wpi6_postmeta table where the meta_key is “_thumbnail_id” for featured images or “attached_file” for other images. The meta_value will give you the ID of the image, which you can then use to find the corresponding entry in the wpi6_posts table.

Please note that the actual image files are stored in the wp-content/uploads directory of your WordPress installation, and the database only stores the URLs and metadata associated with these files.

If you require further assistance or have any additional questions, please do not hesitate to contact us.

Best Regards,
8Theme’s Team

#387381 Copied
Tagged: best woocommerce themes, fix myphpadmin errors, missing blog pictures, myphpadmin blog issues, troubleshooting woocommerce, woocommerce picture attachment
Viewing 2 results - 1 through 2 (of 2 total)