backing up & restoring databases

[bob]

Ive been having difficulity with restoring a database. Its from a different website, trying to move the forum to a different server. All I have from the person is a full-backup, structure-only, and data-only backup from PhpBB2.

What im trying to do, is restore the database file (ive been trying full), to the website. Each time I do it :

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'phpbb2.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 215
File : common.php

Ive gone through the .SQL file and changed the server location, name, path to forum etc to match. Perhaps ive missed something, but regardless of what I try, I keep getting this error.

I know its possible, ive done it once before (somehow). Any ideas?

 

[PTNL]

I'm still just scratching the surface on the whole LAMP environment, but this looks like the error is coming from the query running from your phpBB app, and not from the database restoration process. If so, through what means did you restore the database -- phpMyAdmin, direct server logon and commands, etc.? It really looks like your database restoration didn't succeed.