If you need to migrate your flex.bi Enterprise instance to a different server or host, you need to complete 3 easy steps.
Migrating flex.bi database
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:systemctl stop flexbi
Perform a full dump of the MySQL database. (Exchange
username
andpassword
with the actual credentials of your MySQL Server.)mysqldump -u username -p'password' --all-databases > /home/flexbi/flexbi_mysqldump.sql
Transfer the mysql dump file from the old server to the new one. For example, you can use rsync: (Exchange the
new_server_ip
with the actual IP of the new server.)rsync -avz /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
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.
rsync -avz root@192.168.49.1:/flexbi/* /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
Database file - /flexbi_private/config/database.toml
adapter = "mysql" database = "flexbi" host = "localhost" password = "password" username = "username"
If your database core username or password has changed please edit this file accordingly.
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.
[default_url_options] host = "flex.bi" #port = 8090 protocol = "https"
- Do not forget:
- If you have a web server serving redirects to add flex.bi to it.
- To check if your smtp email server will accept emails sent from the new instance.