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.
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 <discuss@lists.mariadb.org> Sent: Saturday, March 9, 2024 1:26 PM To: discuss@lists.mariadb.org 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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
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 <Simon.Avery@atass-sports.co.uk> 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 discuss@lists.mariadb.org
Sent: Saturday, March 9, 2024 1:26 PM To: discuss@lists.mariadb.org 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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
participants (2)
-
Simon Avery -
Turritopsis Dohrnii Teo En Ming