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?

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

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

root@localhost:~ mysql -u root -p

mysql> create database test;

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;

 

 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;

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 .

5 (1)
Article Rating (1 Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    Migrate jump server installation from one server to another
    Viewed 2700 times since Wed, Jun 14, 2017
    How to upgrade php to 7.2 on Centos
    Viewed 298 times since Wed, Dec 18, 2019
    How to reset mysql or Mariadb root password ?
    Viewed 172 times since Mon, Jun 1, 2020
    How to import servers from a file into Ezeelogin ssh gateway?
    Viewed 2992 times since Fri, Sep 1, 2017
    Enable SSH Key based authentication and Disable Password Authentication in ssh
    Viewed 353 times since Tue, Apr 21, 2020
    How to move servers/migrate servers from one Ezeelogin installation to another?
    Viewed 1871 times since Thu, Jun 15, 2017
    Configuration and error log files to check for troubleshooting
    Viewed 5371 times since Thu, Jun 15, 2017
    Connect jumpserver using putty
    Viewed 843 times since Tue, Apr 2, 2019
    How to install Google authenticator on Centos/Ubuntu?
    Viewed 122 times since Wed, Jun 17, 2020
    How to change the private key in use and change the default public key in use?
    Viewed 3302 times since Fri, Dec 1, 2017