Backup data migration failed from MySQL/MongoDB to PostgreSQL

Backup data migration failed from MySQL/MongoDB to PostgreSQL

KB ID: 115093  
Issue:
Backup data migration encountered failure when migrating from MySQL/MongoDB to PostgreSQL. The error message "Migration Failed" may arise due to the following reasons:
  1. MySQL/MongoDB/PostgreSQL service stopped during the migration process.
  2. Incorrect values in <installation_location>/conf/SGMigration.conf, preventing proper database connection.
  3. Deletion of <dump_location>/Migrate.xml.
Solution:
To successfully complete the backup data migration, follow the steps corresponding to the specific scenario:
For general migration failures (all backups):
1. Stop the VembuBDR service.
2. Ensure MySQL/MongoDB/PostgreSQL services are running.
3. Verify credentials in the <Installation_location>/conf/SGMigration.conf file, specifically in the SourceDB (MySQL) and DestinationDB (PostgreSQL) tags. Ensure passwords are in base64 encoded format.
4. Restart the VembuBDR service.
For a specific backup migration failure:
1. Check and start MySQL/MongoDB/PostgreSQL services if not running.
2. Open the command prompt from <Installation_location> and run the command:  
   `bin\<Product_Name> MigrateFailedBackup <Client_Name> <Backup_Name>`

    • Related Articles

    • Steps to Change MongoDB's Data Storage Location

      KB ID: 97 Challenge: Migrating Vembu BDR's internal MongoDB database data files from one location to another. Cause: As the size of backup data increases, the internal meta-information storage space used by MongoDB in the Vembu BDR server may also ...

    • MySQL Backup & Recovery Overview

      Overview BDRSuite's MySQL Backup solution provides reliable protection for your MySQL databases, ensuring secure backups of your critical data. With BDRSuite, you can easily restore your MySQL databases in the event of accidental deletion, data ...

    • PostgreSQL Backup and Recovery

      PostgreSQL Backup - Overview BDRSuite provides comprehensive backups for PostgreSQL databases, offering granular-level recovery options. With flexible and instant recovery features, BDRSuite ensures seamless data restoration and business continuity ...

    • Vembu BDR v3.7 and Above Migration with PostgreSQL Server

      KB ID: 115041 Objective: Guide users through the migration process of Vembu BDR server (utilizing PostgreSQL) from one machine to another in both physical and virtual environments. Source Machine (Machine A - Old Backup Server): A1: Stop the VembuBDR ...

    • Adding PostgreSQL Database Server for Backup

      PSQL Server can be backed up using the BDRSuite Backup Server. You can simply add the source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add PostgreSQL Database Server. When a PostgreSQL Database ...