cancel
Showing results for 
Search instead for 
Did you mean: 

Problems setting up phpBB

dingbat28
Newbie
Posts: 2
Registered: ‎08-04-2008

Problems setting up phpBB

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   
3 REPLIES 3
Peter_Vaughan
Community Veteran
Posts: 14,469
Registered: ‎30-07-2007

Re: Problems setting up phpBB

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.
Prod_Man
Grafter
Posts: 286
Registered: ‎04-08-2007

Re: Problems setting up phpBB

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 Smiley

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

Jim,
dingbat28
Newbie
Posts: 2
Registered: ‎08-04-2008

Re: Problems setting up phpBB

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