Importer fails to import every post

Open the WXR in a text editor and see if it contains posts from later years. If not, you will need to revisit your export settings from WP.com to make sure you’re pulling all posts.

If it does contain posts from these years, there might be a non UTF8 character breaking the import. You should be able to spot any offending characters in a typical IDE that parses XML. If this is the case, you should edit those characters and retry the import.

Related Posts:

  1. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  2. Export WP database for import using WP-CLI on Vagrant Box
  3. MySQL Syntax Error upon restoring database from backup [closed]
  4. Export / import WordPress database
  5. Merging two databases without borking it
  6. Import users from old WP site to new one
  7. Best practice to import user base (subscribers) from one website to another?
  8. Is it good practice to import/export a blog to test a redesign?
  9. I broke database after reuploading local version – what exactly happened? Database error
  10. Why is my database import losing text widget data?
  11. Best way to import users, post and categories from an external database
  12. What’s the database relationship between a post and its attachments
  13. Importing posts from old website to new conflicting post ID’s?
  14. Exporting revisions
  15. Export wordpress table to excel
  16. When importing database, it shows error
  17. Is a direct or import approach safer for migration into WordPress?
  18. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  19. Importing New Posts from Live Site into Local Dev Site
  20. How much of my site can I recover from public_html?
  21. Import live site to local setup without access to live site
  22. Error establishing a database connection; After importing DB & Theme
  23. WordPress database import: Row size too large
  24. Create a clone from one WordPress site to another in a few minutes
  25. How to Mirror WordPress database from Remote server to Local server
  26. Exporting table to csv works in the admin but exports HTML data when used on the front end
  27. How can i customize the export personal data file?
  28. Importing CSV into database table not working?
  29. WordPress Local And Live Site
  30. Connection refused on locahost after importing database?
  31. Importing Direct to DB – GUID Question
  32. Export a custom Mysql database product catalog to WordPress
  33. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  34. WordPress database products structure
  35. Bulk Edit Media Library alt, caption, image names
  36. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  37. Export only a part of the database for migration
  38. Featured image from custom to WordPress database
  39. Exporting Post type from one theme and importing it to another theme
  40. export individual posts to text files or a single csv file
  41. Saving data to database and exporting to excel
  42. Importing Concrete5 content to WordPress
  43. Problem while importing a site in WPLocal: SQL files fail to import
  44. What is an ORM, how does it work, and how should I use one? [closed]
  45. What is the difference between an ORM and an ODM?
  46. What is this JavaScript “require”?
  47. Rename a table in MySQL
  48. How should I tackle –secure-file-priv in MySQL?
  49. What is this JavaScript “require”?
  50. What is “Advanced” SQL?
  51. What’s the difference between identifying and non-identifying relationships?
  52. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  53. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  54. Export Pervasive to MySQL (C#)
  55. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  56. What are the differences between B trees and B+ trees?
  57. Import / Export database with SQL Server Server Management Studio
  58. MySQL SELECT increment counter
  59. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  60. Example of a strong and weak entity types
  61. Oracle SQL query for Date format
  62. phpMyAdmin – Error > Incorrect format parameter?
  63. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  64. Difference between partition key, composite key and clustering key in Cassandra?
  65. How SID is different from Service name in Oracle tnsnames.ora
  66. What is a relation in database terminology?
  67. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  68. Database vs File system storage
  69. Can I have multiple primary keys in a single table?
  70. Remove Project from Android Studio
  71. Exclude Statement in SQL
  72. How do you query for “is not null” in Mongo?
  73. What is a file based database?
  74. Is it fine to have foreign key as primary key?
  75. Storing Images in DB – Yea or Nay?
  76. Using wpdb to connect to a separate database
  77. how to Optimize WordPress database for 10 million post? [duplicate]
  78. MySQL Database User: Which Privileges are needed?
  79. Where does the Media Library live in the database?
  80. Database synchronization between dev/staging and production
  81. Keeping WP database synced across multiple developers using git
  82. WPDB Insert or if exists Update
  83. Multiple developers / editors working on a site in progress
  84. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  85. get_results using wpdb
  86. Failed to import Media
  87. Will it break my site if I delete all transient records in wp_options table?
  88. Checking if Database Table exists
  89. Why WordPress choose data serialization over json_encode?
  90. What’s the simplest way to backup my WordPress database?
  91. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  92. $wpdb won’t insert NULL into table column
  93. Relaunch 4.2 utf8mb4 database upgrade
  94. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  95. Safest way to bulk delete post revisions
  96. Please explain how WordPress works with MySQL character set and collation at a low level
  97. Solution for database version control and deployment?
  98. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  99. How many users can WordPress handle?
  100. Get error messages when $wpdb->insert() returns false?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)