What’s the database relationship between a post and its attachments

The post that an attachment is related to is determined by the post_parent column on the wp_posts table (depending on your database prefix). Set it to the post_ID of the parent post.

Related Posts:

  1. Export WP database for import using WP-CLI on Vagrant Box
  2. Importing CSV into database table not working?
  3. Featured image from custom to WordPress database
  4. Why is my database import losing text widget data?
  5. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  6. Best way to import users, post and categories from an external database
  7. How to create bulk page and content? [closed]
  8. Importing posts from old website to new conflicting post ID’s?
  9. remove missing image attachments
  10. When importing database, it shows error
  11. Upload files – total size limit – WordPress/Contact Form 7
  12. Get Database Credentials from within the themes file
  13. Is a direct or import approach safer for migration into WordPress?
  14. MySQL Syntax Error upon restoring database from backup [closed]
  15. Import live site to local setup without access to live site
  16. Error establishing a database connection; After importing DB & Theme
  17. WordPress database import: Row size too large
  18. Export / import WordPress database
  19. Bulk-create posts from SQL database
  20. Merging two databases without borking it
  21. Import users from old WP site to new one
  22. import posts with dutch/special letters
  23. Importing 10 Years of Media into the WP Database
  24. Connection refused on locahost after importing database?
  25. Importing Direct to DB – GUID Question
  26. Best practice to import user base (subscribers) from one website to another?
  27. Importer fails to import every post
  28. Location of image metadata on my server
  29. Add pdf to a website
  30. WordPress database products structure
  31. Is it good practice to import/export a blog to test a redesign?
  32. Realtime database update from 3rd party apps (notion, airtable, sheet, etc)
  33. How to fix Uploaded to this post option to see group of images uploaded to a post?
  34. Media Library doesn’t allow uploads? Upload Directory
  35. Media library images “missing” after migrating them using SQL
  36. import (migration) user database to wp-users
  37. I broke database after reuploading local version – what exactly happened? Database error
  38. Importing Concrete5 content to WordPress
  39. Uploaded images not displaying full size preview or inserting into posts
  40. Many images in wp-content/uploads folder that are not in Media Library
  41. I have uploaded thousands of files in the uploads folder via FTP and I want to register them into the database without any plugin
  42. Migration: Copying database content to a different server
  43. Remove empty rows from the database
  44. Check if post id exist in table than only update instead of inserting new row
  45. Detail explanation of wordpress database fields and metatag list [closed]
  46. CreateOrUpdate in WordPress
  47. How to convert srcset links from https to http?
  48. How to get a list of WordPress default database tables?
  49. Can local WordPress installs share /wp-content/ folder and database?
  50. Backing up WordPress database and files
  51. Reattach media after moving to another server
  52. Safely store code(html/js..) into database
  53. Creating and Using Tables in the WordPress Database
  54. Connect a membership plugin to an external database
  55. Compare User meta_value with Product meta_value
  56. Storing user’s data on external database on other server
  57. is it right choose to connect database in template page directly in WordPress site?
  58. How to insert a value to decimal type field using wpdb->prepare?
  59. Sql query to get all metadata for a post
  60. Two separate wordpress installations at one domain
  61. Is there a way to edit the WP content database in an admin panel or external page?
  62. Where do I put my create_new_table function()?
  63. After importing items are not displaying
  64. SQL database import #1046 error
  65. Import images from old WordPress site into new site
  66. Get all top categories, then only 3 posts for each
  67. Having all “non-PHP” files on a different server
  68. Remove special characters from filenames
  69. syntax error for changing user role from database
  70. Finding a page holding a specific string/URL that is used in the content
  71. “wordpress error in establishing database connection” and missing tables
  72. get_option() does unserialize and don’t remove \
  73. next comment id number wordpress
  74. Adding last value from Database as text in WordPress Page
  75. Merging development site with live site
  76. Backup Restore turns carriage returns to literal strings
  77. I have a WordPress 4.6 database dump – how do I use it in a new install?
  78. Local Content different from Remote Content
  79. Check if a database is well installed
  80. Checking if the data already exsis in the wp database – custom plugin
  81. live site do not update after importing sql database
  82. Transforming an wp_options database array into a javascript obect?
  83. WordPress + Postgresql
  84. How can I retrieve data from alternate database using wpdb class?
  85. Database connection close
  86. Author ID mismatch from database
  87. Post attachments doesn’t show after manual db import
  88. MySQL Database User: Which Privileges are needed?
  89. Import Excel (or csv) Table with user-data as subscribers to wordpress
  90. Automatic add record after refreshing page
  91. User accounts for saving form data?
  92. Loop issues when creating custom query for media uploader
  93. Trying to edit a WP site locally using MAMP
  94. SQL query : Select a thumbnail for a media
  95. Correct Syntax for uploading files to custom directory in WordPress
  96. WordPress API standard compliance and specification for external database [closed]
  97. Log IP of users who click a button? [closed]
  98. DROP TABLE IF EXISTS `wp_options` error?
  99. Problem with form database connectivity
  100. Server database problem

Leave a Comment