Category Archives: Uncategorized

How to Find the Path to the MySQL Installation Directory on Windows and Add it to PATH Environment Variable

The main console utilities for working with MySQL are located in the directory where MySQL Server is installed. However, after installing MySQL Server, it is often difficult to find this directory. The best way is to add this path to your PATH environment variable, and then you can use MySQL and mysqldump utilities directly. Continue reading How to Find the Path to the MySQL Installation Directory on Windows and Add it to PATH Environment Variable

How to Automate MySQL Database Backups to S3

If you have an important database, then you need to make sure to back it up regularly. Preferably, you will make sure this happens automatically. But performing regular backups is only half the battle — you also have to consider where to store them. Saving the backups on the same server where the MySQL Server is installed isn’t safe, because if it crashes, you will lose everything. Continue reading How to Automate MySQL Database Backups to S3