This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Backup MariaDb

Hi, I use GTID and want to know right way to backup and restore the data. For example I use followed command in my script:

mysqldump --single -transaction --routines --triggers test > test_backup.sql

I have MasterA(active) and MasterB(slave).

And I want to load third party db, in which node I active or passive we need to loaded.

Thank you for help.

Answer Answered by Faustin Lammler in this comment.

Hi, did you take a look at this documentation? https://mariadb.com/kb/en/library/backup-and-restore-overview

Regards, Faustin

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.