| Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 8:37 AM |
|
|
|
|
Dove |
Posts |
79 |
Word Cnt. |
6,418 |
BDay |
N/A |
Sign |
N/A |
Sex |
|
|
|
|
Joined: Jun 11, 2007
Local time: 9:52 PM
Location: Normally off the planet.
|
|
|
|
|
|
I'm trying to clone a new forum from the database of an existing one. I copied the software, backed up the existing database, created a new database, ran install, then renamed the backup and restored it to the new database.
All worked well until I logged in. And at that point, I get redirected to the old forum, because the configuration of the old forum has been loaded into the new one.
Which means, I cant access the admin section of the new forum at all.
Is there an external mod that accesses the configuration and allows it to be changed ?
If not, how hard is it to make ? Or is there an alternative method of gaining access ?
All suggestions welcome. |
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 9:11 AM |
|
|
|
|
Site Admin |
Posts |
49593 |
Word Cnt. |
2,756,445 |
BDay |
Apr 22 |
Sign |
Taurus |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:52 AM
Location: Texas
|
|
|
|
|
|
Hi circleofatlantis.
I can't answer your question but want to let you know that it may be 4 or 5 hours before Nightrider will be online, however as soon as he reads your post I'm sure he can help you.
Hang in there.
|
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 4:23 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:52 AM
Location: St Pete, FL
|
|
|
|
|
|
What you need to do now is go into your phpbb_config table and modify a few records to point to the new domain. Records that might need adjusting are the following:
- board_email
- cookie_domain
- cookie_name
- EM_ftp_dir
- script_path
- server_name
- xs_ftp_host
- xs_ftp_path
You may not have all of these records, so don't get nervous if you can't find all that I have listed. Just make sure you are viewing all of the records in the table before you give up looking. Don't modify the config_name from the phpbb_config table. Modify the values assigned to the config_value...
You can modify these records using phpMyAdmin in your Host CPanel or you can use MySQL-Front like I use most of the time. If you want to use MySQL-Front, here are the instructions on how to set it up and use it:
MySql-Front Tunnel Info
After you have it installed, you will want to do the following:
- upload the phpMySQL.php file into the root of the phpBB folder. The phpMySQL.php file will be found in your c:\Program Files\MySql-Front folder.
- Then you create a new Session:
- Enter your General tab info:
- Enter your Connection tab info. The path to your phpMySql.php tunnel file will be the path to your board in your browser, plus the phpMySql.php name. It would look something like this:
http://www.yourdomain.com/phpBB2/phpMySQL.php
- Enter your Login tab info. This would be the same as what is set in your config.php file:
- Press the Ok button...
- Click on the File/Open Session menu option:
- Select your new Session from the list and Press the Open button. You will only have one record in your list to choose from:
- If all was set up correctly, you will connect to your database...
Be very careful. There is no undo here. So if you screw up anything, it may be gone forever if you failed to make any backups...
To view the contents of the phpbb_config table, click on the phpbb_config table in the left panel:
In the right panel, click on the Data Browser tab:
At the top left of the app, change the second option to 500, then press the Enter key:
You should now be viewing every record in your phpbb_config table in alphabetical order. Only adjust the values listed in the config_value column:
Let me know if you need clarification on any of these steps...
|
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 4:26 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:52 AM
Location: St Pete, FL
|
|
|
|
|
|
Also, don't forget to adjust the settings in your config.php file to point to your new database. You can edit the config.php file using any decent text editor...
|
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 10:08 PM |
|
|
|
|
Dove |
Posts |
79 |
Word Cnt. |
6,418 |
BDay |
N/A |
Sign |
N/A |
Sex |
|
|
|
|
Joined: Jun 11, 2007
Local time: 9:52 PM
Location: Normally off the planet.
|
|
|
|
|
|
Thankyou, that did the trick nicely.
I didnt even know that function was there. Now I do. Also gives me the ability to wipe the old PM's file away too
rb2d2, thanks, but it didnt matter. I posted and then went to bed, so the answer was available as soon as I got back in anyway. Appreciate the gesture though. |
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 11:10 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:52 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, you can empty the PM table as well as the Posts table if you are starting the new forum from scratch. Did you use phpMyAdmin or were you able to get MySQL-Front working???
|
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/13/2010 11:17 PM |
|
|
|
|
Dove |
Posts |
79 |
Word Cnt. |
6,418 |
BDay |
N/A |
Sign |
N/A |
Sex |
|
|
|
|
Joined: Jun 11, 2007
Local time: 9:52 PM
Location: Normally off the planet.
|
|
|
|
|
|
phpMyAdmin worked fine. |
|
|
|
|
Back to Top |
|
|
| Re: Is there a mod to modify the configuration externally ? | |
Posted: 03/14/2010 12:52 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:52 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, you might want to try using MySQL-Front too. I don't use MySQL-Front to Export or Import the database, but it is very helpful when I want to modify records in it...
|
|
|
|
|
Back to Top |
|
|
| Information | |
|