How do I copy all of my blog posts and pages from live site to local site

  • Hello guys,

    I’ve kind of done things backwards. I set up my site first live. However, now I am using instant wordpress and want to copy all of my post and pages from live site to local site. I have transfered all of my images (uploads) but I am not sure about blog post and pages.

    I am sure I am missing something here. Can anyone help?

    Thanks,

    James
    https://www.jimmyesl.com

Viewing 3 replies - 1 through 3 (of 3 total)

  • All your posts are stored in the database. So you want to transfer some of your online database to your local site. It would be easy if you were happy to transfer everything, but thi is likely too much (like the admin login password etc).
    In the situation where I have a local and online website, at installation I configure my wp-config.php file to have the same nonce/salt values, then in cases like this I can backup the database, replace the website URL in the backup, and load the local database from it.
    Maybe you only have to transfer some and not all of your tables.

    It may be helpful in your situation to simply export your content from the live site then import it to the test site.

    Head over to “Tool” then “Export” and from there you can select all the content you’d like to export. Then simple import the content in the same manner.

    Hope this helps!

    WordPress saves all the data elements in database. So if you want to moves pages and posts to your localhost, its recommended to take backup of database.

    1. Go to your phpmyadmin and select your database.

    2. Click on export.

    3. Click on Go.

    It will create a backup of WordPress database. You can import this database backup on your localhost phpmyadmin.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How do I copy all of my blog posts and pages from live site to local site’ is closed to new replies.