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
    How to move servers/migrate servers from one Ezeelogin installation to another?
    Viewed 1995 times since Thu, Jun 15, 2017
    How to convert the ppk files to openssh format
    Viewed 9396 times since Fri, Aug 3, 2018
    Enable SSH Key based authentication and Disable Password Authentication in ssh
    Viewed 532 times since Tue, Apr 21, 2020
    How to reset mysql or Mariadb root password ?
    Viewed 263 times since Mon, Jun 1, 2020
    How to install Google authenticator on Centos/Ubuntu?
    Viewed 198 times since Wed, Jun 17, 2020
    How do i export all server password into an excel file?
    Viewed 2088 times since Thu, Jun 15, 2017
    MariaDB Connector Vulnerability CVE-2020-13249
    Viewed 235 times since Wed, Jun 17, 2020
    Connect jumpserver using putty
    Viewed 951 times since Tue, Apr 2, 2019
    Configuration and error log files to check for troubleshooting
    Viewed 5677 times since Thu, Jun 15, 2017
    How to re-add a reinstalled server?
    Viewed 349 times since Tue, Apr 21, 2020