AhsayCBSAhsay Go MariaDB Backup and Restore
Ahsay Go provides a comprehensive backup solution for your MariaDB Database Server. It delivers automated and secure database backups with encryption and different storage support. It can safeguard business data against hardware failure, accidental deletion, corruption and ransomware attacks through immutable backup protections and reliable recovery options.
MariaDB Database Backup Method
MariaDB Database backup uses a spooling method to make a consistent snapshot of the database(s) for backup.
For each database backup job Ahsay Go will trigger MariaDB to spool or make a copy of the database (.sql) file to the temporary folder using the mysqldump utility.
MySQLDump Parameters
Here is the mysqldump parameter list used for generating the spooled dump file:
- --databases
- --password
- --result-file
- --port
- --user
- --host
- --opt
- --quote-names
- --allow-keywords
- --triggers
Example:
For the spooling of the “nation” database to a %folder_path% 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=%folder_path%\nation.sql
For details on mysqldump parameters, please refer to mysqldump - A Database Backup Program
For further discussion regarding MariaDB backup and restore, refer to the following pages: