Moving a PHPBB Forum

[ZephyrWarrior]

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

[floridaflatlander]

I'd go to the phpbb forums, this should be a standard problem for people moving a forum and you should have people there that could point you in the right direction.

For example, smf has a file repair_settings that walks you through many of the things you're talking about.