Migration/conversion from BIND9 Mysql to BIND9 Zone files

[kimsondergaard]

Hi Guys

Im new in this forum, and have searched a little bit, for a solution to my problem.
but can't find one.

We have been hosting websites on Mac's,(Not my choice) and are now moving to cPanel.
one of the things that are currently hosting on mac's, is our nameservers(NS1-4).
They run Bind, which is looking in a MySql database, in the migration from mac's to totally running in cPanel, i would like to move out NS into cPanel DNSonly.

But how can i import/convert these mysql strings, so i can use them in cpanel which as far as i know, is using zone files, stored in /var/named/.....

And easy and stable solutions ?

 

[cPanelMichael]

Hello @kimsondergaard,

We don't provide any tools to automate the conversion of those zone files. How many zone files do you need to convert? If it's just a few, the easiest approach is to simply manually create the zone files through cPanel & WHM and then use WHM >> Edit DNS Zone to add in the custom records.

Thank you.

 

[kimsondergaard]

Okay i found a way to export our DNS records, and no i can't do this manually.
We have over 30.000 records in the DNS database.

There is 2 way's i am considering, 1. php / mysql, coding my way out of it, getting the information with Db connection, and while loops. 2. using DIG, to get the DNS record, editing the result, and writing to a file, and then move it to the correct folder.

 

[kimsondergaard]

@cPanelMichael

Where do cPanel bind, store httpr/web redirects ?
I have almost solved the first part of the DNs migration, but i am missing the HTTPR.
In our present solution, this is stored in a seperate mysql table, and looks lige this "host:www.domain.org URL:www.otherdomain.org"

 

[cPanelMichael]

Hello @kimsondergaard,

Can you provide a link to documentation on that function? If I understand correctly, I believe you'd need to use a CNAME entry. EX:

www    14400    IN    CNAME    domain.tld.

Thank you.

 

[kimsondergaard]

Hi @cPanelMichael

I figured it out, we had another server that made the redirect.
Are cPanel able to handle creating a new user, to a domain which is already in the DNS ?
I tried, but it says i have to delete the dns record, to create the new user, with the existing domain.

There must be a workaround ?

 

[cPanelMichael]

Are cPanel able to handle creating a new user, to a domain which is already in the DNS ?
I tried, but it says i have to delete the dns record, to create the new user, with the existing domain.

Hello,

You can't skip the zone creation when creating an account. You'd need to backup the DNS zone, delete it, create the account, and then replace the contents of the zone with the contents that were backed up.

Thank you.