Open Bee™ Data Importer uses an internal MySQL database.

The following is how to migrate this database from one workstation to another:

1. Back up the database
   • “PATH_MYSQL\bin\mysqldump” -u root dataimporter > dataimporter_backup.sql
   • Example withMySQL Port = 3307, password = pass, MySQL folder path = C:\Program Files (x86)\OpenBee\Open Bee Data Importer\mysql\bin
     • “C:\Program Files (x86)\OpenBee\Open Bee Data Importe\rmysql\bin\mysqldump” -P 3307 -u root -ppass dataimporter > “C:\dataimporter_backup.sql”
2. If necessary, install MySQL on the destination workstation
3. If it does not exist, create a blank database “dataimporter”
   • “PATH_MYSQL\bin\mysqladmin” -u root -p[password] create “dataimporter”
   • Example “C:\Program Files (x86)\mysql\bin\mysqladmin” -u root -ppass create “dataimporter”
4. Re-import the database
   • “PATH_MYSQL\bin\mysql” -u root -p[password] dataimporter > dataimporter_backup.sql
   • Example “C:\Program Files (x86)\mysql\bin\mysql” -u root -ppass dataimporter < C:\dataimporter_backup.sql

Application migration

1. Install Open Bee™ Data Importer on the new workstation
2. Copy from the workstation to be migrated to the destination workstation, the following folders:
   • C:\Program Files (x86)\OpenBee\Open Bee Data Importer\Configuration
   • C:\Program Files (x86)\OpenBee\Open Bee Data Importer\ImportsData
   • C:\Program Files (x86)\OpenBee\Open Bee Data Importer\Temp
3. Run Open Bee™ Data Importer
4. Configure the database connection, if it has been moved (Configuration => Settings => Database)
5. If necessary, modify the file deposit path in the import profiles