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. Get a term each custom post type
  13. Post titles and thumbnails as links to custom post types?
  14. Custom Post Type, post-formats associated to custom post type > 404 archives
  15. Cannot select certain authors for posts after import
  16. How to display only one category in a custom post type?
  17. Adding a custom post type meta field to rss
  18. How do I allow certain users to make a certain type of post?
  19. How to restore deleted post related with deleted users
  20. Help with listing current users submitted custom post type in template file
  21. How to add a post class on every post. (on homepage)
  22. Delete post from admin but not from database
  23. I can’t find the relevant part of the loop in my theme file. How do I find the full content with “More…”
  24. why the posts queried from sql is more than those showed on the page?
  25. Custom Post Type Single Loop Outputting Wrong Post
  26. add_rewrite_rule and template redirect not working
  27. WordPress Architecture as a CMS – Posts & Pages
  28. Getting post and attached image from subdomain
  29. Custom post type slideshow background images to insert in a plugin
  30. Organization of time insensitive content
  31. Custom Select Query – Selecting the Year?
  32. Deleting old posts
  33. How To Use Custom Tax of a Post Type
  34. Am getting duplicate data from get_posts()
  35. How to output all taxonomy links from a custom post type in a menu?
  36. Prevent duplicate pages from being added
  37. Can I style single post that are in multiple catergories?
  38. Trying to exclude custom posts based on date, while sorting by custom field
  39. WordPress Post Deletion Issue
  40. How Can I Always Display A Particular Post First Using WP_Query?
  41. What would causes search to return incorrect results?
  42. Help on conditional statement to accompany wp_insert_post function please?
  43. Changing permalink of WordPress
  44. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  45. how or where wordress collect unlogged user session
  46. Can I restore restore content from old Worpress site to a new Worpress site from an archive
  47. Hook save_post_cpt not triggered when custom fields are modified
  48. Turn off display for custom sidebar post widget when on the post it’s displaying
  49. Add a field in my rest api
  50. Permanently deleted posts still exist
  51. created post displaying differently on front end
  52. get posts, run a custom query, and join the results
  53. Aligning images in the wp editor not working. How do i get this to work in custom theme?
  54. How to bulk Update URLs to new values?
  55. search form for custom fields
  56. How to put the author of the post in the comments?
  57. unable to write to the database while uploading images
  58. Alt text attributes not showing over portfolio images
  59. My website is showing today’s date instead of published date since db migration to a new wordpress
  60. How to pull latest posts from a specific category
  61. Displaying all posts from other sites on the network on one site
  62. Adding an option to post editor to show a site disclaimer or message
  63. Search results for ACF data
  64. Problem paginating a subquery on a post
  65. How to add a custom class attribute into code wrapper? [duplicate]
  66. Redirecting wordpress search query to archive page
  67. Multisite how to display merged posts from two sites and sort by latest date?
  68. Some custom post types did not return an object
  69. Include Recent Post in Category
  70. Display Post from Custom Post Type with Shortcode
  71. Pagination Not Working With Custom Post Type Category
  72. Redirect to custom post if custom archive page has just one result?
  73. Tag for custom post type
  74. How to create custom search form function including post “tags”
  75. Added a ACF field to custom page and want the results to show as a column in admin
  76. Modified core/image rendering not showing in posts – only on pages
  77. WordPress Pods Custom Post Type – separate Media Upload folder for each custom Post Types
  78. Not display an image of category of custom post
  79. How to invoke a HTML custom button based on a HTML dropdownlist menu
  80. Show post count in custom taxonomy page
  81. Posts not showing content after migration
  82. Hide or remove custom post status
  83. Template for displaying CPT / Taxonomy URL issues
  84. Multiple posts in one page
  85. Put page on Archived statut after end of publication date
  86. Moved a website and excerpts don’t work for old posts
  87. Multisite Issue on Subdomain’s article pages
  88. post and page and custom post type
  89. Please I want to prefix my WP posts title according to each category
  90. Post relationships/nesting
  91. How to prevent clicking on posts
  92. insert post fails after multiple postings
  93. delete post hook not being fired when deling in wordpress dashboard admin
  94. Manual Scheduler For Custom Post Type
  95. WordPress Delete Users from backend doesn’t work
  96. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  97. Custom Post Type Rewrite URL
  98. Dev and prod on the same database- dev version active for IOS
  99. Is it possible to make a custom post that adds multiple pages?
  100. Custom Post Types and Broken Permalinks
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)