Help with PHPBB

[CliffyG]

I have moved some forums into my personal webspace and imported the sql database but i think i'm still unable to view them because some of the General Config options aren't relevant on my site. I can't find which file specifies what domain name and script path is to be used and obviously can't load the forums admin section. Does anyone know where this info is stored?

 

[CliffyG]

That just has database info in.

 

[CliffyG]

Thanks that table had the domain name in it. I've stumbled across another problem though which i hadn't noticed before. I have imported the sql structure but when i try and import the data it comes up with the following error:

SQL query:

INSERT INTO phpbb_search_wordlist( word_text, word_id, word_common )
VALUES (

'applyíng', '19435', '0'
);



MySQL said:

#1062 - Duplicate entry 'applyíng' for key 1

None of the tables after the one that errored are populated.

 

[CliffyG]

Ouch, that's a character set conflict. It's interpreting that as "applying".

Meaning .

EDIT

From what i can tell that table is basically an index for searching. I've deleted all the references from the text file (don't have access to phpmyadmin on the original site) and it seems to have gotten further on the upload. Not sure of the implications of not filling the table though.

EDIT 2
Keeps bloody timing out now too, the file is around 16mb and doesn't import much over 5. How can i get round this without exporting the tables individually?

 

[CliffyG]

Anyone?

 

[CliffyG]

I think the long way round would be opening the text file and splitting it into smaller chunks for upload. Probably would be a lot quicker than getting my host to do it and as it's pretty important that i get it turned around asap after i switch off the forums in the old location it looks like my only way forward .