Page Comparison

...

1. Before starting the migration process, stop flex.bi 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 -p'password' --all-databases > /home/flexbi/flexbi_mysqldump.sql

   
   

3. Transfer the mysql dump file from the old server to the new one. For example, you can use rsync: .
   To do this, run this command on the old server.  (Exchange the new_server_ip with the actual IP of the new server.)

   Code Block
   rsync -avz /home/flexbi/flexbi_mysqldump.sql root@new_server_ip:/home/flexbi/flexbi_mysqldump.sql

   Launch this command

   
   

4. Import the transferred mysql dump file into the MySQL server on the new server.

   Change 192.168.49.1 to your old servers ip address.

Lastly import the transferred mysqldump file

1.  (Exchange username and password with the actual credentials of your MySQL Server.)

   Code Block
   mysql -u 'username' -

...

1. p'password' < /home/flexbi/flexbi_mysqldump.sql

   
   

...

...

Migrating flex.bi Enterprise files and import data

...

1. To migrate all of your files to your new location server you should be able to just copy them from one server to another using rsync.
   To do this, run this command on the old server. (Exchange the new_server_ip with the actual IP of the new server.)

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

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

   
   

Adjusting flex.bi Enterprise configuration files

1. Database file - If you have changed MySQL database user or password used for flex.bi, then make the necessary adjustments in the /flexbi_private/config/database.toml file. 

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

   
   

   
   

2. If your database core username or password has changed please edit this file accordingly.Flexbi configuration file - the hostname or internet protocol used for flex.bi Enterprise server has changed, adjust the following part of the /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.

   file.

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

   Do not forget: 

   
   

   Info
   If you

   have

   are using a web server

   serving

   making redirects to

   add

   the flex.bi

   to it.To check if your smtp

   Enterprise server, adjust the configuration of the web server

   
   

   Info
   Check if your SMTP email server will accept emails sent from the new

   instance

   flex.bi Enterprise server.