CloudBacko Go brings you specialized module, MariaDB Module, to provide a set of tools to protect your MariaDB Database Server.
Below is the system architecture diagram illustrating the major elements involved in the backup and restore process. In this user guide, we will focus on the end-to-end backup and restore process using CloudBacko Go backup software.
CloudBacko Go's MariaDB Database backup uses a spooling method to make a consistent snapshot of the database(s) for backup. For each database backup job, CloudBacko Go will trigger MariaDB to spool or make a copy of the database (.sql) file to the temporary folder using the mysqldump utility.
Here is the mysqldump parameter list used for generating the spooled dump file:
For the spooling of the “nation” database to D:\Temp folder, the following parameters will be used: Mysqldump –databases nation –user=user1 –password=qwerty –host=localhost –port=3306 –opt –quote-names –allow-keywords –triggers –result-file=D:\Temp\nation.sql For details on mysqldump parameters please refer to https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html