I am making a backup strategy for MariaDB on Windows Server.
To make my life easier, I was wondering if I can use the "Windows Server Backup function" or "wbadmin" as a backup tool for MariaDB.
1 Answer
You can, but I doubt it will make your life easier. wbadmin isn't a general backup tool applicable to everything, and in addition to that databases often have specially designed backup procedures. For example, wbadmin isn't inteded as a tool to backup even for Microsoft's own SQL Server.
First is to think about how you are going to restore from these backups and what else you might want to do. Then, please, read this carefully: Backup and Restore Overview.
The backup must follow this procedure:
- Connect to MariaDB and lock tables:
FLUSH TABLES WITH READ LOCK. Don't disconnect, this session must survive at least until step 3. - Start a backup using
wbadmin. - When VSS service finishes making a shadow copy, you can quit session started at the step 1, releasing a lock.
Steps 1 and 3 are essential.
answered Feb 18, 2021 at 7:29
- Thanks. Shutdown MariaDB and do the backup is another option, isn't it?Xin– Xin2021-02-18 10:03:21 +00:00Commented Feb 18, 2021 at 10:03
- Of course. Usually people want to do backups "without service disruption". If you can afford stopping a service, you can really do absolutely any method to back up its files.Nikita Kipriyanov– Nikita Kipriyanov2021-02-18 11:51:04 +00:00Commented Feb 18, 2021 at 11:51