Hi Turritopsis, On backups:
If the windows machines are vms, then back up the vms themselves. Quickest way to restore, and with a decent snapshotting backup, low impact. We run a backup of each vm every hour or so, retaining a week's worth - and then have normal backups as well. When we need to recover a table, then we restore the vm to a new IP, dump the table and restore it on the live machine. If they're physical machines or the above isn't suitable, then I imagine the Windows version of Mariadb will come with Windows builds of its associated tools - one of which will be "mysqldump" - there are plenty of guides to use this, here's just one: https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database Alternatively, there are lots of free and commercial backup solutions for mariadb (and mysql which will probably also work for Maria), some of which will rotate the backups and transfer them to a remote machine for you, if that's what you want. Simon -----Original Message----- From: Turritopsis Dohrnii Teo En Ming via discuss <[email protected]> Sent: Saturday, March 9, 2024 1:26 PM To: [email protected] Subject: [MariaDB discuss] Backup MariaDB Databases for Suprema BioStar 2 Door Access System Subject: Backup MariaDB Databases for Suprema BioStar 2 Door Access System Good day from Singapore, On 7 March 2024 Thursday, when I was installing new self-signed SSL certificate for the door access system for a law firm in Singapore, I notice that Suprema BioStar 2 also uses the open source MariaDB database server. If I did not remember wrongly, there are 3 databases. However, the entire platform is a Windows environment, not Linux. How can I backup all the databases in the MariaDB database server? Thank you. Regards, Mr. Turritopsis Dohrnii Teo En Ming Targeted Individual in Singapore Blogs: https://tdtemcerts.blogspot.com https://tdtemcerts.wordpress.com GIMP also stands for Government-Induced Medical Problems. _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
