Andrew Hale: IT Talk & Other Topics

Generally, backing up an SQL DB and restoring it is relatively straightforward. Most of the guides talk about backing up and restoring a DB on the same host. Some might talk about pulling down a backup from a remote location and restoring it locally. But, what about when both of your servers are remote and you're SSH'd into one of them? This took me a bit of digging the first time I did this so I wanted to put this information in one place, whether it's for someone like you who's Googling or for myself in a couple years when I have to do this again.

As mentioned before, I'm setting up a LAMP stack using Cent OS v7 on my Raspberry Pi 3. LAMP stands for Linux, Apache, MySQL and PHP. The A for Apache could also be E for Nginx (pronounced like Engine-Ecks) and the P for PHP could also be P for Perl or Python. This software together forms what's referred to as a "stack", which is simply a common development term for a set of software that works together for a specific application. In this post, I'll be covering the installation and initial configuration of Apache, MySQL and PHP.