Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

How can I get blog content from SFTP?

All of WP’s blog content is in the database that is used by the blog. The database name is found in the wp-config.php file.

You could do a fresh WP install in a new folder (or new host or new local WP instance), then change the wp-config.php file for the old database : database name, user, password. That won’t copy over all of your themes/plugins, although any theme/plugin data stored in the wp-config table will be there if you install/activate the theme.

All of the posts are in the wp-posts table (as well as pages and media), but it’s a bit complex to extract posts from the wp-posts table.

If you want to see the site’s posts/pages, then the above procedure will get you started.

Related Posts:

  1. Can you have a blog in a subdirectory hosted on a different server?
  2. Move WordPress from /blog folder to root but leave post at /blog
  3. Moving my current wordpress blog to a subdomain
  4. Could not load the preview image. Please reload the page and try again – error on image upload
  5. How to display blog posts on a dedicated page?
  6. Two Blog Layouts, Same Theme
  7. Show first sentence of blog post in blog roll
  8. Keep WYSIWYG on Blog Page
  9. Detect archive and category page
  10. Custom URL for all posts in WordPress
  11. List all blog categories
  12. A garbled copy of MY blog on this site? [closed]
  13. A different thumbnail to the blog index vs. the image on the top of a post?
  14. Deleting a blog
  15. Why does this snippet in a blog post make WordPress crash?
  16. How to move all theme templates into a subfolder WP
  17. Where can I find my blog page?
  18. How to display the posts and news in front page?
  19. How do I change the taglines next to the featured image on my posts?
  20. WordPress Blog – Grid View
  21. How to show latest blog post rather then earliest
  22. inviting people to blog and editing roles
  23. Removing blog page images
  24. problem with wordpress author profile page URL
  25. How to make blog posts appear under different menu items?
  26. Portfolio & Blog cohabitation : multiple single.php files?
  27. How to add list of other blogs, with latest posts from those blogs, to a single page of my website?
  28. Put post urls into their own category
  29. I want to display my 2. latest post
  30. Why the Gutenberg Editor is Not Available In My WP Site?
  31. How to prevent WordPress from auto creating ol li on list elements?
  32. How do I add a sign up form to my blog?
  33. WordPress blog assign unqiue body class
  34. I am getting “0” in the starting of my post description at home page
  35. How can I make my Blog category unindexed in Google?
  36. Recent Posts Listed by Author, Can I exclude authors?
  37. How to modify display of blog listing page?
  38. Internal and External Blog
  39. Can I make a parent page of the blog and have it display a paragraph/thumbnail of certain entries?
  40. How can I set a vote on the comments?
  41. Making a column vector in wordpress blog using Latex
  42. How do you allow users to subscribe to a WordPress blog?
  43. Blog on a separate server from WooCommerce WITHOUT effecting SEO?
  44. what is the address of default home page?
  45. Creating new page overwrites old page
  46. How to set condition for all posts with one label
  47. Blogs got Deleted automatically
  48. Integrate wordpress blog into existing html site
  49. Retrieve details of my wordpress site
  50. Blog post stuck in drafts
  51. I need to customize wordpress “previous” “next” links
  52. I Have No List Of Blogs – Empty Blog Folder Recreating Itself
  53. How to change the layout of blog posts to that a compressed snippet shows rather than full text
  54. Can I create mini-WordPresses on my WordPress?
  55. How to create library of HTML snippets to use in posts
  56. Adding a WordPress Blog to a current WordPress site
  57. Two blogs one page
  58. Blog Displays Only Sticky Posts
  59. Uploading a external squeeze page within WP
  60. Posts page drop down is not selecting the selected page
  61. URL of blog when using index.php as blog and front-page.php as homepage
  62. Not showing up on WordPress Reader
  63. Blog as a part of a WordPress site?
  64. Fatal error: require() [function.require]: Failed opening required in wordpress
  65. how to show content of latest blog post with read more link?
  66. Auto-posting Facebook posts to blog [closed]
  67. How to access the so called “Posts page”
  68. Home page of blog displays no posts
  69. How to turn off “you have to login to comment” on blogs
  70. Why do I get undefined function export_wp()?
  71. “There doesn’t seem to be a wp-config.php file.” despite wp-config.php in root
  72. How blog page in WordPress works : blog page retrieve first post ID
  73. Showing a list of posts when homepage is custom
  74. Show certain posts in a LIST format that members have been granted access to
  75. get author in blog posts?
  76. Is it possible to send blog posts via email to subscribers?
  77. unable to add custom page/tab to my account woocommerce
  78. How to get the latest URL of my blog?
  79. Later blog post pages give 404 error
  80. Is there a way to multiply archive loop results sequentially?
  81. Display subcategories in dropdown
  82. WordPress loop is not working
  83. Tag,php – how to get it to display featured post image? [closed]
  84. Create a List of Widgets, where each widget holds three attributes
  85. How to create category filter on a blog like on the site below?
  86. Serve contents from Nextcloud / WebDAV
  87. Blog Page doesn’t show summary but full content
  88. LinkedIn Share Post Button
  89. My posts page is missing the page title
  90. Blog Post slider not working
  91. Edit Posts Page but not category specific pages?
  92. Excert ( the_excerpt(); ) Not working properly
  93. Get image paths from RSS feeds
  94. 2 tick boxes appearing below comments
  95. No error in debug mode, wordpress template can not be loaded
  96. Show Site Name on WP login screen
  97. Article Template
  98. Persistent sidebar.php [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. Do Not Back Up? Is there any accepted way to tell backup and clone plugins to skip a certain file? [closed]
Categories blog Tags account, blog, bloginfo, filesystem
Remove Unwanted Font Files from Loading into WordPress Frontend
bloginfo url in javascript

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress