In this guide, you will learn how to create a shell script that will backup all of your MySQL databases. You will also learn how to setup a scheduled task to run the backup script daily.
Most WordPress websites are hosted on a Linux server and yet a lot of developers will use a Windows machine and a program like WAMP to develop their sites. In my opinion, it’s better to use a Linux machine so that your development environment closely matches the production server.
Note: If you don’t want to use Linux as your desktop machine, you can use a virtualisation program like VMware so that you can run Linux inside a virtual machine.
In this tutorial, we will assume you are using Ubuntu 16.04 as your workstation (either physical or as a virtual machine). You will learn how to install Apache, MySQL, PHP and Postfix and then configure a test WordPress site.