A one click solution to make backups of your local XAMPP databases.
With a single click, this script exports all local XAMPP databases and saves them to a directory of your choice. For optimal peace-of-mind, it is recommended that the backup destination is part of an existing scheduled backup routine and, if possible, located on a different physical drive. Alternatively, the destination should be any directory that is automatically backed up to the cloud.
If you are familiar with PHP, the configuration should be straightforward.
/* Config */
$host = 'localhost'; // MySQL server hostname
$username = ''; // MySQL server username
$password = ''; // MySQL server password
$backup_destination_dir = 'D:\sql-backups'; // Destination directory to store SQL dumps
$mysqldump_exe = 'C:/xampp/mysql/bin/mysqldump.exe'; // Where the mysqldump.exe executable currently resides.
To run the script locally, place the index.php file in your httpdocs directory under a folder of your choice. For example: c:/xampp/httpdocs/sql-backups/index.php. Ensure that you can access it through your browser just like any other local website.
Recommend changing the $date variable to use a date format that suits you.
To exclude specific databases from the backup, add their names to the array at line 86.
This script has been tested on Windows with PHP 8.0.