Editing a WordPress site on a live server is quick and simple. It’s also one step away from disaster. The goal of this talk is to give you all the knowledge and tools you need to develop WordPress on a local machine, and then to push those changes to a live website. We will automate as much of the process as possible, giving you more time to actually develop your site instead of copying files back and forth or clicking dozens of menus to export and import databases. Topics discussed will include local web servers and databases, file version control (Git), and database synchronization.
Here is a list of resources I mention in the talk:
- Git Tutorial
- Deploying Git automatically to a server
- How to Sync A Local & Remote WordPress Blog Using Version Control
Not mentioned during the talk, but here are my favorite Git clients
Here is the command SQL code I referenced:
1) Run this command on the live server:
2) Transfer database_name.sql locally (using scp or sftp)
3) Run this command on the local server:
4) Run this command on the local server:
The contents of update.sql should look like so:
Of course, replacing “local_folder_name” with the name of your website.