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 can we upgrade php in an ezeelogin installed server ?
    Viewed 904 times since Fri, Jan 25, 2019
    How to install Google authenticator on Centos/Ubuntu?
    Viewed 44 times since Wed, Jun 17, 2020
    Will i be locked out of my servers if my ezeelogin hosted server goes down ?
    Viewed 2630 times since Mon, Aug 21, 2017
    How to upgrade OpenSSH in Centos ?
    Viewed 58 times since Wed, Jul 22, 2020
    How to prevent putty window from closing during ssh
    Viewed 119 times since Wed, Apr 22, 2020
    How to convert the ppk files to openssh format
    Viewed 7470 times since Fri, Aug 3, 2018
    Database connectivity credentials and configuration file
    Viewed 1679 times since Thu, Nov 23, 2017
    How to truncate the ssh session logs recorded
    Viewed 1835 times since Tue, Dec 5, 2017
    Connect jumpserver using putty
    Viewed 751 times since Tue, Apr 2, 2019
    How to export servers ?
    Viewed 3457 times since Sat, Sep 2, 2017