Reply
Thu 24 Jun, 2004 03:58 am
Hi there, I hope I can find help here.
I tried phpbb.com but there wasnt any good.
I have changed web hosting company.
The database which i want to restore, has no username prefix at front of database name.
but, every database created in my new web hosting, has a prefix at the front generated.
When i restored the database, i am unable to do anything from there coz the database names are both different.
Things that i have tried:
1- ask web hosting company to override the prefix, but unsuccessful
2- modify the backup database to add in the prefix all over
3- flush cache n temp files
Any suggestion to get around the prefix?
ok. i have also tried adding a prefix to the backuped database name. and made changes to config.php
then i drop database, and installed phpBB again.
replaced config.php.
restored modified database
everything looks fine in acp but when i clicked on "preview forum" "forum index " or "mass email", theres an error page generated.
Having a name as a prefix to the database is a host setting. Asking them to change is is unreasonable as it is the way their virtual hosting is set up and there's no reason they should (your problem is easy to solve).
Just change the config file to accurately relect the info and you are set.
Sounds like you did, and the problems you report do not sound like they have anything to do with the database (except prhaps some settings in the configuration options that are stored there.
Thanks for the feedback. Web hosting did not chnage its web hosting setup and i ran out of ideas on how to go abt it. Reinstalled a new phpbb instead :-)
Dude, you can just change the dbname in the config file. That's all it takes.
hi, I tried changing dbname in config file too but it didnt work. its all weird. I suspect that i have messed up the dir structure and hence restore stuffed up.
no worries. :-)
ps. I have installed mod rewrite 1.0.0 and when clicking on a forum in guest mode, i get a 404. any idea where i stuffed up this time?