WordPress.org

Ready to get started?Download WordPress

Forums

How to keep local WordPress updated with latest posts? (7 posts)

  1. vurtomatic
    Member
    Posted 4 years ago #

    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?

  2. figaro
    Member
    Posted 4 years ago #

    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)

  3. vurtomatic
    Member
    Posted 4 years ago #

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

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

  4. figaro
    Member
    Posted 4 years ago #

    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...

  5. vurtomatic
    Member
    Posted 4 years ago #

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

  6. Pinoy.ca
    Member
    Posted 4 years ago #

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

  7. figaro
    Member
    Posted 4 years ago #

    There is no "sync" option

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

Topic Closed

This topic has been closed to new replies.

About this Topic