Dear Simon, Thank you for your reply.
I don't think I want to backup the whole Windows operating system. I will just use mysqldump to backup and restore MariaDB databases. Thank you. Regards, Mr. Turritopsis Dohrnii Teo En Ming Targeted Individual in Singapore On Tuesday, March 12th, 2024 at 9:40 PM, Simon Avery <[email protected]> wrote: > 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]
