How to keep local WordPress updated with latest posts?

  • I managed to create a local install of WordPress, did the database export and import fine, everything’s fine.

    But what I’m wondering is, how do I keep my local WordPress continually updated with the hosted WordPress?

    Do I simply repeat the database export/import process? I am thinking that might end up creating duplicate entries in my local install.

    I only want to update my local WordPress with the latest posts.

    Any ideas?

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

  • Do I simply repeat the database export/import process?

    Yes, that will work…just drop the tables from your localhost install and import new sql file…all should be the same then — except for any new stuff in wp-content (uploads, themes, plugins)

    Thread Starter vurtomatic

    (@vurtomatic)

    So it’s basically re-creating the whole database and files?

    There’s no other way to just update the different/new files/posts?

    So it’s basically re-creating the whole database and files?

    No, it’s re-creating the db tables…which, on an average size db, takes all of about 5 seconds. I do this all the time on a 500mb (relatively large) db…takes a couple minutes to dump and download the live db, a couple minutes to search/replace the url, and a couple of minutes to import into my localhost install using bigdump.

    I’m sure there are other, more advanced ways, but this is simple…not a lot of chance for error and it works every time.

    If you want your files as well, then you need to copy down your wp-content…I guess you could set-up some kind of sync program for this, but unless you are talking about gigs of stuff, then I really don’t see a reason…

    Thread Starter vurtomatic

    (@vurtomatic)

    Thanks, appreciate it. I am still getting my head around the idea of databases and db tables.

    MySQL has limited or no support for differential backup, transactional log backup, mirroring, replication or log shipping. There is no “sync” option.

    There is no “sync” option

    I was talking about a sync option for files (wp-content)…not the db.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to keep local WordPress updated with latest posts?’ is closed to new replies.

Tags