MySQL

Scheduled MySQL databases backups on Windows really simply…

Scheduled MySQL databases backups on Windows really simply…

A simple, scheduled MySQL database backup method with zipped files, archive pruning and FTP/offsite upload After a fruitless search for free MySQL backup tools, the solution turned out to be surprising – using good old-fashioned batch scripting to surprising affect! This leverages the MySQLDump tool which produces .sql files as backups. This simple script will backup selected databases and d... »

Automatically encrypt database connection strings in Visual Studio

Automatically encrypt database connection strings in Visual Studio

This article shows you how to automatically preserve your database connection string in app.config whilst also deploying an encrypted version in your production app…. In my example, I am connecting to a remote MySQL database from a winforms app. Add your data source via the usual means, choosing to save your password and store in app.config: The open ProjectSettings > Compile > BuildEv... »