Unable to restore from backup – how to obtain old blog posts?

Here are the steps I would take.

  1. Make a backup of the database backup and store it someplace safe
  2. Find out what version of WordPress the site was running when the
    backup was done like this:

    • open the sql dump file in a text editor and search for db_version.
    • Use that value to find the corresponding WordPress version, here.
  3. Install that version of WordPress locally or on a dev site (subdomain or whatever)
  4. Follow the instructions for migrating a site to a new domain (i.e. localhost or dev.example.com)
  5. Use the WordPress/tools/export tool to export the posts.
  6. Import that .xml file into the new blog

Related Posts:

  1. Redirect to another page using contact form 7? [closed]
  2. how to enable different number of revisions for different blogs when using WPMU?
  3. How to hook a function only when I need to delete permanently a post?
  4. I am unable to publish/update post
  5. WordPress Multisite – Create Default Post and New Category On New Site Install
  6. Is there a way to create a meta box that can be added multiple times to a post dynamically?
  7. Change default post style to columns
  8. Change modified date to current date when title updated automatically
  9. How can I have the posts from one word press blog show on the presentation page of another word press site
  10. How to show the posts list into a static page? Problems to use the loop into a static page
  11. How to show only the date, the title and a little “summary” of my WordPress post in my custom theme?
  12. How to display by default only published posts/pages in the admin area?
  13. Find out who deleted a page or post?
  14. Post/Page Preview Template
  15. using wp_update_post on save_post
  16. Replace image attributes for lazyload plugin (data-src)
  17. WordPress plugin to publish to multiple remote WordPress blogs
  18. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  19. How do I sort (order) the results from `get_children()`?
  20. How to display comments and comment form on custom post type?
  21. how to display full post with pagination on home page
  22. How to wrap every image in a post with a div?
  23. Show One Category on Post
  24. WordPress Delete hook with wp_delete_post function?
  25. Custom post type single (permalink) throws a 404 error
  26. Order post by year DESC and month ASC
  27. How to create post in WP network using WP-CLI
  28. Do I use custom post type or something else?
  29. how “manage_posts_custom_column” action hook relate to “manage_${post_type}_columns” filter hook?
  30. Delete Post From Front-End and attachment permanently
  31. Custom post type permalinks breaking due to 3.1 bug fix
  32. Importing New Posts from Live Site into Local Dev Site
  33. ‘Invalid post type’ error when importing from one site to another
  34. Changing next and previous post link text
  35. Blogroll – Different layout for first post
  36. How to delete old posts’ edits to save space?
  37. Get post id in wordpress action?
  38. Edit custom post type admin menu link
  39. How to include a post type in the admin/backend?
  40. How to make number of blog posts a custom field?
  41. WordPress blog or WordPress website
  42. Using custom post template
  43. Hiding Draft Post In Admin
  44. Adding custom fields to bbpress reply form
  45. How to use format post in a pertinent way
  46. Making a custom Pagination for multi page blog post
  47. Permission issue with custom post type – not added to menu – by plugin
  48. Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
  49. Add a custom meta box in the post options that loads some html code in the header
  50. Static posts page with home.php
  51. Is it possible to customize the post according to post format in single.php?
  52. How to transfer one domain to another domain without losing theme options (customizer)?
  53. Using setup_postdata() with multi-dimensional array
  54. Display password protected posts to logged in users
  55. how to hide empty fields of post category description?
  56. Move posts from a non-wordpress site to wordpress
  57. Display the 2nd category name of a custom post type without error if its null?
  58. Querying another post category to match current post and display in loop
  59. Display Featured Posts Grid on Static Page (Gazette)
  60. how to handle the loop using filling bootstrap grid structure?
  61. datepicker value in mysql
  62. Simple Custom Metabox Not Saving
  63. How to restore deleted post related with deleted users
  64. How to add a post class on every post. (on homepage)
  65. why the posts queried from sql is more than those showed on the page?
  66. Custom Post Type Single Loop Outputting Wrong Post
  67. How to output all taxonomy links from a custom post type in a menu?
  68. Prevent duplicate pages from being added
  69. Can I style single post that are in multiple catergories?
  70. WordPress Post Deletion Issue
  71. How Can I Always Display A Particular Post First Using WP_Query?
  72. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  73. Aligning images in the wp editor not working. How do i get this to work in custom theme?
  74. How to put the author of the post in the comments?
  75. unable to write to the database while uploading images
  76. My website is showing today’s date instead of published date since db migration to a new wordpress
  77. How to add a custom class attribute into code wrapper? [duplicate]
  78. Redirecting wordpress search query to archive page
  79. How to invoke a HTML custom button based on a HTML dropdownlist menu
  80. Posts not showing content after migration
  81. Please I want to prefix my WP posts title according to each category
  82. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  83. Custom Post Type Rewrite URL
  84. Custom Post Types and Broken Permalinks
  85. The first post appears twice
  86. Customizing URL slugs of Custom Post Type and Taxonomy make posts/pages 404
  87. creating a custom post template
  88. Show Posts By Custom Field
  89. How to retrieve custom field values and save again as array
  90. Is there a Standard Format for Clean URLs for Archives of Custom Posts?
  91. Customize search results to include custom posts and display in a specific template page
  92. Custom permalink based on custom post type fields
  93. Checking if some condition is matched before inserting post into database
  94. Custom Post Title as search term
  95. adding custom meta as well as looping through posts
  96. How remove “recent comments” title without modifying code? [closed]
  97. Get posts after calculating meta key
  98. How edit footer copyright info? [closed]
  99. Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields
  100. Site ‘Categories’: save an admin global setting with post metadata [closed]