Page Comparison

To If you need to migrate your flex.bi Enterprise instance to a different server or host there are three easy steps which you should be aware of: 

...

, you need to complete 3 easy steps.

Migrating flex.bi

...

database

1. Before starting the migration process

   please power off the

   , stop flex.bi

   service (usually by executing " /etc/init.d/flexbi stop")First you need to do a full mysql data dump.

   Enterprise service. For example, if you are using systemd initialization script on Linux, run the following command:

   Code Block
   systemctl stop flexbi

   
   

2. Perform a full dump of the MySQL database. (Exchange username and password with the actual credentials of your MySQL Server.)

   Code Block
   mysqldump -u username -

   ppassword

   p'password' --all-databases > /home/flexbi/flexbi_mysqldump.sql

   
   

3. Next using rsync (or other methods) you should transfer the mysqldump

   Transfer the mysql dump file from the old server

   , e.g.:

   to the new one. For example, you can use rsync: (Exchange the new_server_ip with the actual IP of the new server.)

   Code Block
   rsync -avz

   root@192.168.49.1:

   /home/flexbi/flexbi_mysqldump.sql root@new_server_ip:/home/flexbi/flexbi_mysqldump.sql

   Launch this command on the new server. Change 192.168.49.1 to your old servers ip address.

Lastly import the transferred mysqldump file

mysql -u username -ppassword < /home/flexbi/flexbi_mysqldump.sql

It is advised to use a full mysql dump when exporting and importing data. The target mysql should be empty and must not contain any databases which share names with your original flex.bi mysql database. 

More about mysqldump and actions associated - https://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

Migrating flex.bi Enterprise files and

...

import data

1. To migrate all of your files to your new location you should be able to just copy them from one server to another using rsync.

   Code Block
   rsync -avz root@192.168.49.1:/flexbi/* /flexbi/

   1. Launch this command on the new server. Change 192.168.49.1 to your old servers ip address.

   Editing configuration files

Adjusting flex.bi Enterprise configuration files

1. Database file - /flexbi_private/config/database.toml

   Code Block
   adapter = "mysql" database = "flexbi" host = "localhost" password = "password" username = "username"

   If your database core username or password has changed please edit this file accordingly.

2. Flexbi configuration file - /flexbi_private/config/eazybi.toml or /flexbi_private/config/flexbi.toml.

   Find these lines and change accordingly if your hostname or security measures have changed.

   Code Block
   [default_url_options] host = "flex.bi" #port = 8090 protocol = "https"

   
   

1. Do not forget: 
   1. If you have a web server serving redirects to add flex.bi to it.
   2. To check if your smtp email server will accept emails sent from the new instance.