This was originally written for myself only, but I have extended it a lot and chose to put it up here. It’s a really simple VB.NET program which can make backups of a MySQL database on a remote webserver.
All that the webserver requires is PHP and of course MySQL.
The program works by autogenerating a custom PHP file, uploading it to the FTP server provided and then downloading the backup from that. And after that it deletes the PHP File for added security.
The PHP file itself is secured by a random authentication key generated upon making the file.
This program can be used standalone or as most people properly will do, integrate it into your own program and extend it however you wish. If you know a little VB you can customize it and sell it with your web solution so the client can back up his / her website with ease.
I’ve tested the backup feature on a lot of sites. And it have always worked. Even on complete (and very big) WordPress sites.
NOTE !
The program only creates a backup of the database. It cannot roll it back to the server. The backup format is standard SQL query so you can just execute it however you like (for example through the import feature of PHPMyAdmin).