Hart Associates - Advertising, Interactive, Public Relations, Video, Media » tcoleman

Blog

Our Five Favorite Lines of SQL

July 13th, 2009, 0 Comment(s)

Whenever we’re doing any WordPress development, we eventually have the need to sync the data between the current development server, possibly a staging server, and a live server. What’s the easiest way to move a WordPress database between two servers?

Let’s start this example by saying that we have two servers: Dev and Live. Each server has a mostly identical WordPress installation and each server has it’s own database. In order to sync the initial database from Dev to Live, the following steps may be used:
Read More…