Domain Price Transfer

[Emhope]

Hello,

 

I am looking to transfer across the list of domain extensions and prices form our main WHMCS website to a new fresh install. Which tables do I need to transfer across?

 

I can see tbldomainpricing has a list of domain extensions and tblpricing contains the pricing. Are there any more tables which are required.

 

Thank you

[sentq]

make sure that the following tables are empty in the "fresh install", then export data from old database to the new one:

tbldomainpricing

tbltlds

 

and for "tblpricing" you need to export pricing related for domains only, using this query will list domain related records:

SELECT * FROM `tblpricing` WHERE `type` IN ("domainregister", "domaintransfer", "domainrenew", "domainaddons")

 

also exclude tblpricing.id from data exported to avoid any issues with the new database, if it has existing records

[Emhope]

Thank you.