How to Synchronize WordPress Live and Development Databases
Category: Database, Deployment, joelf, mysql, PHP, siteground, Wordpress, Workflow
Developing WordPress themes is considerably easier with real content. Unexpected situations begin to arise when people add pages, posts, media and comments. Your beautiful template can break when:
- editors use assets which are too big or small for your breakpoints to handle
- managers introduce a new menu item which doesn’t fit at lower screen sizes
- your theme implements a two-level menu hierarchy which fails to cater for the inevitable third-level page
- long or deeply-nested comments become unreadable.
Ideally, your development server should have a snapshot of your live production server’s database. Your workflow can be improved further if content is automatically synchronized when changes occur.
One-way WordPress database replication can be more challenging than you expect. There are good reasons why few coders live in this development dreamland…
Continue reading %How to Synchronize WordPress Live and Development Databases%
LEAVE A REPLY
You must be logged in to post a comment.