I have these settings in my zone file and I want to add a CNAME for my web traffic to use instead. Do I delete these A records, or do I edit them to work with my new CNAME below? (xxx.xxx.xx.xx is my old server IP which I will no longer be using)
www A xxx.xxx.xx.xx
mydomain.com. A xxx.xxx.xx.xx
and I need to add a CNAME like this
www CNAME 123456.group32.sites.hubspot.net
yes, you will have to delete your A records first.
Please keep in mind you can not (not advisable) have a CNAME for the "naked" domain (e.g. yourdomain without subdomain).