Ok, so me and a friend of mine own a gaming community and a couple server through NFO.
Initially we had one Garrysmod server which came with web-hosting, but we've now become popular enough to afford a VPS, and our own web-hosting.
So I set out to move our forums and come across this:
1 – Backup your mysql database table (using hosting provider tools or phpadmin)
2 – Backup your forum directory (using hosting provider tools or ftp)
3 – Setup your new hosting provider
4 – Import your mysql database
5 – Upload you phpbb forum directory
6 – Do any required tweaks to config.php file (if your mysql datbase, username, password has changed)
7 – Then put your live site in offline mode
8 – Change your domain name ns servers to new hosting provider ns servers
9 – Now just wait to DNS replicate takes affect over the WWW
I did step 1 via PHPMyAdmin, successful export to a .sql file
I did step 2 via Filezilla.
Step 3 is done.
But on step 4, I come across this:
SQL query:
--
-- Database: `nexttiergaming_database`
--
CREATE DATABASE `nexttiergaming_database` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said:
#1044 - Access denied for user 'ntg'@'localhost' to database 'nexttiergaming_database'
Now, I initially thought that this was due to NFO's database naming system (x_y, where x is the name of the web-hosting and y is a custom name you choose), and because the web-hostings had different names, that the databases were incompatible. I then tried to rename the database on the original web-hosting, and was met by a similar error.
I contacted NFO support and they said this:
'It is doubtful. But you should make it what the new ID is and then change it in the config for the forums. But like I said you are treading in territories we cannot support.'
Can I get some help on the matter?
Thanks in advance,
ZephyrWarrior