Problems setting up phpBB

[#1]

I am about to take over an existing Bully Board using phpBB2....the problem I am having is that the database backup is 3.8mb zipped. I get an error message if I try and restore through phpBB or phpMyAdmin. I have tried phpbigdump also but get an error message about a duplicate entry. There is obviously as size limit of 2048k via phpMyAdmin coz it says so.
Has anybody any ideas how to get this database uploaded.
I have also had a good hunt to see if I could find if there is a limit to the number of tables or size of database etc that PLUSNET allows, any know
thanks in anticipation   

[#2]

The table limit is so big as to not be a problem.
You will need to use the command line mysql application to import your data.
First ftp your mysql backup to your ccgi webspace
Login to your ccgi shell via telnet or ssh (http://usertools.plus.net/tutorials/id/18)
gunzip the backup file so it is a .sql file
use mysql to import the data from the .sql file

mysql -h HHHHHH -u UUUUUU -p DDDDDD < file.sql
HHHHHH - MYSQL Host (rumpus or humbug)
UUUUUU - Username
DDDDDD - DB Name
You will be asked to type in your password and then the data will be imported.

[#3]

Yeah, that's the most reliable way do do it.
No space between the "-p" argument and password,
else there is no point parsing the password in the first place.
else you'll be there all night wondering why it's not working

mysql -h <HOST> -u <USER> -pPASSWORD < file.sql

Jim,

[#4]

Thanks alot worked a treat, took a few attempts to get the format correct but got the job done in the end