Steps to Change the MySQL Data Directory Location

Steps to Change the MySQL Data Directory Location

KB ID: 115037
Challenge:
Migrating BDRSuite internal database (MySQL) data files from one location to another.
Solution:
For Windows:
1. Stop the BDRSuite and MySQL Services in services.msc.
2. Open the "my.ini" file in the MySQL installation location and locate the "datadir" attribute to find the current "data" folder location.
3. Copy the MySQL "data" folder from the old location to the new location.
4. Update the "datadir" attribute with the new location in the “my.ini” file.
5. Start BDRSuite and MySQL services.
For Ubuntu:
1. Stop the BDRSuite and MySQL Services using the following commands:
    /etc/init.d/mysql stop
    /etc/init.d/vembubdr stop
2. Navigate to the "/var/lib/" location and find the "mysql" folder.
3. Copy the "mysql" folder to the new location.
4. Open the "my.cnf" file in the "/etc" location and locate the "datadir" attribute. Update it with the new location where you copied the "mysql" folder.
5. Start BDRSuite and MySQL services using the following commands:
    /etc/init.d/mysql start
    /etc/init.d/vembubdr start

    • 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 ...

    • Steps to Change the PostgreSQL Data Storage Location in BDRSuite Backup Server/BDRSuite Offsite DR Server

      KB ID: 115042 Challenge: You need to migrate the internal PostgreSQL database files of the BDRSuite Backup Server/BDRSuite Offsite DR from one location to another due to increased storage space requirements resulting from the growing backup data ...

    • 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: MySQL/MongoDB/PostgreSQL service stopped during the migration ...

    • Changing BDRSuite Client Data Storage Location

      KB ID: 115097 Purpose: To migrate internal database files of BDRsuite Client from one location to another. Cause: In BDRSuite client, when a significant number of files are added to the backup job, the internal meta-information (sgprp database) ...

    • 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 ...