I wish to move my XenForo website from a shared host to a dedicated server running Debian. I have done a bit of research on how to do this, but I'm still quite confused as to how exactly I'd go about doing so.
I have Apache2 and Php installed. So far all I've done is copied my website's files and uploaded it to "/var/www." I'm not entirely sure if that's the correct place to upload the files, though..
The next thing I'd have to do is copy over the MySQL database? On my shared host, I don't seem to have access to SSH. Is there a way to copy the MySQL database either through FTP or cPanel? From there, how would I go about "importing" the database to my new host? I run other things on the machine that require MySQL and I do have PhpMyAdmin installed.. however I don't think I can use that. I do, obviously, have SSH access to the dedicated server -- is there a command line to import the database some how?
So, if I'm able to move the files over and if anyone can help me on how to move the databases, would that be it, or is there anything else I'd need to do to get the website working on a new host?
Finally, how would I make the numerical IP address use my domain? So for example, if my dedicated server's IP is xxx.xx.xx.xx, how would I turn that into mydomain.com? I'm extremely new to this, so bear with me please. I'm using cPanel's "DNS Zone Editor" right now. If I try to make a CName or A record, it requires <blah>.mydomain.com. I simply want people to be able to go to "mydomain.com" or "mydomain.com/forums" or whatever the URL is to access the website. Right now people can access the website via "mydomain.com" because I'm using a shared host's web-hosting service type thing. Sorry again, I'm extremely new to this, but perhaps someone could be so kind as to help me.
Any help would be greatly appreciated!