i used to have a DB on hostgator however i want to eliminate that and just stick to my dedicated server, i downloaded my .sql file from PHPMyAdmin and would like to be able to somehow still use this data but on my dedicated server.
With MySQL you will have to create the DB (as root typically) then create a user and assign said user a password. Then you will assign that DB to the user you just created with all privileges.
You will then need to import the SQL file (and hope it's not corrupted) that you exported from phpMyAdmin into the new DB you created (either as the user or as root).
If you aren't familiar with doing this, then I would suggest an unmanaged dedicated server might not be the best option to go live with at this time unless you have some additional help that is familiar with those processes.
Honestly, it sounds like you should have stayed with a host, or got cPanel on your new server. No way should you be using an unmanaged dedicated server if you don't know how to do these sorts of tasks.
Ah alright ill try thanks, also how can i get it to automatically place a thread prefix in a certain forum, because i have something for my MC server called Staff Applications and i would like that when they post it places that automatically as currently im manually doing it
Oh wow, well if you could help if not would help ALOT,
i moved my xenforo from HostGator to my dedicated server i use for my mc server on SYS
However since i moved everything is fine except The following error occurred: Not Found
The requested URL /login/ was not found on this server.