I want to transfer my website (let's say www.mydomain.com), which is currently running on a shared hosting, to my VPS server, which I recently bought.
I created a domain in the DirectAdmin of my VPS server, with the same name as the domain name which is currently running on the shared hosting (www.mydomain.com). Now I uploaded the website and database to this domain on my VPS, and it is working correctly.
Now, I only need to change de DNS from my current shared hosting to this VPS. But here's where it gets a bit confusing for me.
Let's say the VPS server has the IP address 12.12.12.12. Then the domain which I created via the DirectAdmin is running on 12.12.12.12/~admin/. I already created a DNS A record (server.mydomain.com) on my sharedhosting, which is pointing to the IP address of the server. But when I try to reach this record, it doesn't show me the website but only 'Apache is functionating normally'.
Now, what do I have to change in my DNS settings to have the domain pointing to the website which is running on my VPS server (12.12.12.12/~admin/)?