Media library images “missing” after migrating them using SQL

Ended up taking a different approach – I exported all the content I had already created so I didn’t lose it, used the WB Migrate DB Pro plugin to import the content I wanted to carry over from my old site, and them imported all the new data again. A bit roundabout but effective!

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. Solution for database version control and deployment?
  5. How to migrate a HTTPS WordPress installation to localhost?
  6. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  7. Migrating data between local and development server
  8. Best way to import users, post and categories from an external database
  9. What’s the database relationship between a post and its attachments
  10. Syncing local content with development / staging sites
  11. Organizing WP Pages based on old website database
  12. Presentation vs Content in WP DB-Tables
  13. remove missing image attachments
  14. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  15. Migrate a Non WordPress database to wordpress [closed]
  16. Weird issue with database migration and SSL links
  17. How to fix unchanged URLs in Database after running serialized search and replace script?
  18. Migrating database / content of non-CMS site to WordPress
  19. How do I reset a self-hosted WordPress URL?
  20. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  21. Export all content from wordpress
  22. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  23. Moving minor updates between local and live sites – just database?
  24. How to move the WordPress site Layout from test site to Production site?
  25. Merging two databases without borking it
  26. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  27. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  28. Trouble Migrating all data blog from WordPress.com to WordPress.org
  29. Copying database tables to new database
  30. Migrating from PDO using SQLite to clean new install using MySQL
  31. Migration: Copying database content to a different server
  32. Change WordPress URL in sql file via Terminal
  33. Strange characters added to the database
  34. After database migration, theme mods don’t show [closed]
  35. Problem migrating to localhost
  36. WordPress url transformation script
  37. How to transfer from localHost to live but use the already existing database on the server?
  38. Image link issues after importing a database backup to my local web server
  39. Database migration issues – Error #1046 No database selected
  40. echo site_url() returns a different value than what is in the database siteurl field
  41. Migrate Users From laravel to wordpress
  42. /wp-admin not accessible after migrating to local host (no plugin issue)
  43. How to fix Uploaded to this post option to see group of images uploaded to a post?
  44. How do you enable scripts on a WordPress installation in Softaculous?
  45. WordPress site migration – locked out of admin area
  46. Malware in old website – how to migrate?
  47. WP website showing blank page after moving from subdomain to main domain
  48. WordPress Migration – Issue with admin panel changes
  49. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  50. How to edit posts/pages without making the change live?
  51. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  52. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  53. I cannot change anything in my wordpress database from within wordpress?
  54. Media Library doesn’t allow uploads? Upload Directory
  55. Restoring .sql backup results in “Error establishing a database connection”
  56. Database Name Change
  57. import (migration) user database to wp-users
  58. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  59. Moving database from WP 2.6 to 3.5 problem
  60. Media Library won’t recognize SOME old files after move
  61. Importing Concrete5 content to WordPress
  62. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  63. Many images in wp-content/uploads folder that are not in Media Library
  64. Using wpdb to connect to a separate database
  65. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  66. Exporting revisions
  67. WP_Options ID high
  68. How to use multiple database in wordpress?
  69. Gel all image from certain post type
  70. Is removing orphaned wp_postmeta records safe?
  71. Get url from file uploaded in Media Library
  72. Set Display Name to first and last name (phpmyadmin SQL Query)
  73. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  74. SQL Error wp_commentmeta – incorrect table definition
  75. WordPress database error – Error in SQL syntax – I can’t identify any error?
  76. Merging two wp_posts tables while avoiding duplicates
  77. How can i add custom fields into the contact form 7 [closed]
  78. Move out of sync posts from one database to another
  79. MS Access to manage WordPress Database
  80. Custom WordPress Table wpdb
  81. CreateOrUpdate in WordPress
  82. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  83. Can local WordPress installs share /wp-content/ folder and database?
  84. Stringing together content from different databases
  85. Safely store code(html/js..) into database
  86. Compare User meta_value with Product meta_value
  87. My website is showing today’s date instead of published date since db migration to a new wordpress
  88. Sql query to get all metadata for a post
  89. Where do I put my create_new_table function()?
  90. How to import products in host instead of database on wordpress?
  91. syntax error for changing user role from database
  92. get_option() does unserialize and don’t remove \
  93. Want to update value in database. But it says update() on null
  94. Merging development site with live site
  95. live site do not update after importing sql database
  96. Transforming an wp_options database array into a javascript obect?
  97. Is there a way to add Reattach and Unattach links in image gallery?
  98. Where To Find bb_profile_data(); In bbPress?
  99. Host Images from Link
  100. WP Multisite Users Not Linking