Presence Builder Trial Import

Trial Website Import Instructions

-WebPresence builder Instructions: webpresence sitebuilder server

-Webpresence.4goodhosting.com port 22

-Database sitebuilder5

mysql> select * from site_owner where email='kenyi2001@gmail.com' \G
   * 1. row *
   id: 814
   personal_name: ken yi
   company_name: smartlife technology
       phone: 604-888-8888
       email: kenyi2001@gmail.com
     address: 123 hastings st
        city: burnaby
       state: bc
         zip: V5B 1S2
     country: canada
   1 row in set (0.00 sec)

mysql> select * from site_owner where personal_name like 'USERNAME'\G

Get the UUID of the user with USERID from site table
Table site

mysql> select uuid from site where site_owner_id=814 \G
   * 1. row *
    uuid: a6f6e05b-1fb7-a151-425f-908e8a5c074b
    1 row in set (0.04 sec)

Update the state to 2 (that is trial to live) in the site table where uuid = id above ,

Then replace UUID(c968d2e6-4b85-f974-8f6d-8372159b6091) in Shared server /home/username/.cpanel/nvdata/webpresencebuilder with UUID(a6f6e05b-1fb7-a151-425f-908e8a5c074b) — this to import it to his account.

cat  /home/username/.cpanel/nvdata/webpresencebuilder
a:1:{s:8:"__MAINu";s:36:"c968d2e6-4b85-f974-8f6d-8372159b6091";}

mysql> update site set state = 2 where uuid = 'a6f6e05b-1fb7-a151-425f-908e8a5c074b';
mysql> update site set state = 2 where uuid='c968d2e6-4b85-f974-8f6d-8372159b6091';

Cpanel > Presence Builder > Edit → we can find the new demo site for the user.

Done

NOTE: If you didn't find file webpresencebuilder under /home/username/.cpanel/nvdata, You will need to create the site from the client cPanel > WebPresence.