How to migrate the custom server fields from Ezeelogin version 7.0 to the latest version?

How to migrate the custom server fields and server field values?

Overview: This article explains the process of migrating custom server fields and server field values from an older Ezeelogin version 7 to a newer version. It involves creating a backup of the old version, setting up a test database in MySQL, restoring the database, truncating specific tables, and copying the necessary server fields and values using SQL queries. Users must replace placeholder database names with the actual names in their environment.

Step 1. Take the backup of old Ezeelogin version 7 and untar the backup using the following command

root@localhost :~ sh ezlogin_backup_v7.0.0_b381_Tue_Jul_14_2020_05_32_45_UTC.bin --noexec --keep --target temp

Step 2. Log into the MySQL as root and then create a test database

root@localhost:~ mysql -u root -p

mysql> create database test;

Step 3. Restore the Ezeelogin database to the test database

root@localhost:~ cd temp/

root@localhost:~ mysql test < database.sql -p

You should truncate the server_fields and server_field_values table before importing the data by using the following queries:

mysql > TRUNCATE ezeelogindatabaseLatest_name.dbprefix(latest)_server_fields;
 mysql> TRUNCATE ezeelogindatabaseLatest_name.dbprefix(latest)_server_field_values;

Step 4. Login to your MySQL as root and update the following query to copy the server fields

root@localhost:~ mysql -u root -p
mysql > INSERT INTO latest_ezeelogindatabasename.dbprefix(latest)_server_fields (id,name,type,options,description,encrypted,sortorder,created,mtime) SELECT  id,name,type,options,description,encrypted,sortorder,created,mtime FROM ezeeloginversion7databasename.dbprefixezverion7_server_fields;

Step 5. Login to your MySQL as root and update the following query to copy the server field values

root@localhost:~ mysql -u root -p

mysql > INSERT INTO latest_ezeelogindatabasename.dbprefix(latest)_server_field_values SELECT * FROM ezeeloginversion7database name.dbprefixezeeloginverion7_server_field_values;

Replace latest_ezeelogindatabase with the name of latest Ezeelogin version database name and ezeeloginversion7databasename with the database name of Ezeelogin version 7.

Upgrade Ezeelogin Jump server to the latest version

Migrate jump server installation from one server to another

Migrate Ezeelogin database to RDS / remote SQL instance

Basic MySQL commands for troubleshooting database related issues in Ezeelogin