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 do i export all server password into an excel file?
    Viewed 2324 times since Thu, Jun 15, 2017
    Is the software upgrade seamless from free to paid? Do i have to reinstall?
    Viewed 1827 times since Mon, Aug 21, 2017
    How to reset mysql or Mariadb root password ?
    Viewed 471 times since Mon, Jun 1, 2020
    Is it a hosted solution?
    Viewed 1900 times since Mon, Aug 21, 2017
    Migrate jump server installation from one server to another
    Viewed 3179 times since Wed, Jun 14, 2017
    Deleting entries in the mysql database table serveractivity_logs
    Viewed 48 times since Tue, Mar 2, 2021
    How to set user password lifetime for expiry
    Viewed 501 times since Wed, Apr 15, 2020
    How to convert the ppk files to openssh format
    Viewed 11491 times since Fri, Aug 3, 2018
    How to upgrade OpenSSH in Centos ?
    Viewed 1101 times since Wed, Jul 22, 2020
    How to import servers from a file into Ezeelogin ssh gateway?
    Viewed 3382 times since Fri, Sep 1, 2017