Sync local DB to remote server for Wordpress?

by techcloud7

Posted: 11 years ago 6 replies

WEB DESIGN

I develop Wordpress sites called techcloud7.com, and I have a local XAMPP But every time when I post anything I personally need to update Live database for the every post.tell me something how can get a mechanism so that if I posted something on localhost that will automatically get updated on live server.

#local #remote #server #sync #wordpress

Andrew H 11 years ago

Running a Development Copy of WordPress « WordPress Codex
- Thanks
Signature

"You shouldn't come here and set yourself up as the resident wizard of oz."
{{ DiscussionBoard.errors[8243628].message }}
loveya 11 years ago

I'm also looking for this solution.
- Thanks
{{ DiscussionBoard.errors[8456044].message }}
RobinInTexas 11 years ago

I've seen this question numerous times, I don't recall a solution, other than using a plugin like WordPress › Import any XML or CSV File to WordPress « WordPress Plugins but for a post at a time it would be easier to copy/paste.
- Thanks
Signature

Robin

...Even if you're on the right track, you'll get run over if you just set there.
{{ DiscussionBoard.errors[8456141].message }}
David V 11 years ago

Deploying via Github is quite popular and productive, but a little technical.
It's worth learning as it will make things much easier.

Here's a few articles that may get you headed in the right direction.

How to deploy sites via Github

Syncing website files between local and live servers using GIT?

Deploy your site with git

A free Git & Mercurial client for Windows or Mac (great for newbies)
- Thanks
- 1 reply
{{ DiscussionBoard.errors[8457220].message }}
- RobinInTexas 11 years ago
  
  It would seem to me that's a lot more work than a simple copy/paste if all you are doing is posts.
  
  I also see a potential problem in that an active/live WordPress website can be updating it's database tables while you are doing the same with a local installation.
  
  Thanks
  
  Signature
  
  Robin
  
  ...Even if you're on the right track, you'll get run over if you just set there.
  
  {{ DiscussionBoard.errors[8458803].message }}
David V 11 years ago

Short term I'd agree on that.
Longer term a sync/push either direction is super easy and efficient.
Obviously he/she? only asked about a post, but there will be much more to do. (updates, style changes, etc...)
- Thanks
{{ DiscussionBoard.errors[8458824].message }}

Sync local DB to remote server for Wordpress?

Trending Topics

Been a while! Any of you Old Timers here?

How much does the rebranding affect CR ?

Are billboards still effective in driving customers?

Boat and Jet Ski Rentals...... Door Hangers Effective?

A Very Strange Internet Problem