I am a rank NOOB. I have a forum on a free forum site, and I stayed up all night working on moving the forum to my localhost on my windows xp so that I can eventually move it to a paid server.
okay. over all these hours, I have cut and paste all the best info that I could find that helped me. Maybe some of it will help someone in here.
For those who happen to want to install the whole shebang on a winxp, I installed apache 2.2 and php 4.4.6, then php was not 'exactly' compatible so I had to download php4apache2_2.dll . later I needed to know, but no one really says, that your username is root ! (isnt that a riot?) then because of another 'slight' incompatibility, you need to force mysql 4.1.22 to use the old password method and set that in the my.ini file.
it's all good.
then I was ready to install PHPBB, but the backup file from the free forum was so big that it bombed out after 1200 seconds (20 minutes) a few times.. anyways.. to solve that, remember I am loading it on my home pc, so I went into a command prompt and used msyql to import the backup.sql
Oh, and this command, I spent hours before I found out that I needed it:
mysql> CREATE DATABASE phpBB2;
that is not obvious to a NOOB
I also found this command:
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP ON phpBB2.* TO 'phpBB2user'@'localhost' IDENTIFIED BY 'dbpassword';
so that I could install phpbb.
I am getting to the solution in a second.
then, I really didnt like the looks of phpMyAdmin, it looks too complicated to install, and maybe I was tired too, so I searched around and found an old defunct (ahem) mysql front end mgr, and when I ran phpbb it bombed out on the aluminoid template... rats.. but I came here, thank you, and download aluminoid and did not know how to install it.
but.. I saw silver one in the template folder, so I tossed aluminoid in there, and the forum came up!
but, like many here on this thread, when I logged in, the forum was running off to the other server. So I used that mysql front end and changed four things based on this cut and paste that I found:
UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'cookie_domain';
UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'server_name';
UPDATE phpbb_config SET config_value = 'path_to_phpBB' WHERE config_name = 'cookie_path';
UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'script_path';
Just replace the blue (WHERE) text with the appropriate values. Watch out with the cookie domain and server name. You cannot include http:// or it will not work.
basically domain name is localhost and phpbb path for me is /phpBB2/
logged into the forum again, and it is all fixed.
yep, test message I just posted on it, went local.
so the answer is not the cookie script, I dont think. I am a NOOB. The answer is to use your phpMyAdmin and fix those four locations, and then recheck them from your admin screen also. and for restoring huge forums to move to another server, I think doing it on your local pc and then FTP it over to the new server, would be easier.
I hope all this makes sense, and someone gets help from searching on the some of the keywords.
oh the import command I used to merge my old forum into a fresh install of phpbb was:
>mysql -u USERNAME -p DATABASE_NAME < backup.sql
for me it was
mysql -u root -p phpBB2 < e:/mysql/backup.sql
it took over 20 minutes, but no crashes.