I recently had the need of making changes to my website but I didn’t want to have those changes live until I have tested in my local environment.
Downloading the remote files and running a local server is pretty trivial. Making a backup of the remote database can be accomplished using phpMyAdmin or you can use any WordPress backup plugin (I personally like WP-DB-Backup)
The part that is annoying (at least in my case), is that I used CPanel+Fantastico to automatically create an instance of WordPress in my server. The issue is that the database credentials (name, username, password) are generated with some weird values. In my local copy I have to modify the
wp-config.php file to add the credentials to connect to my local database. The problem with this is that I always have to remember not to upload the
wp-config.php to the live server to prevent taking my own site down.
I figured that I should probably modify the
wp-config.php in a way that will work in my local environment as well as the remote server. Here is a quick way to support multiple databases in WordPress by modifying the
// local environment
// remote environment