Moving a phpBB forum to a new server

[zachtib]

I want to move my phpBB forum onto another server in order to user my current server for a linux test box to try out new distros before I install them.

I make nightly mysql dumps, can I just restore the latest dump and then move all the php files over?
How can I restore a .sql file to a mysql database?

[cvncpu]

yes you can, i did this exact same thing, just move all the phpBB files over, and restore the databse. it is that easy

[kode]

mysql -u &#91;username&#93; -D &#91;database&#93; -p  < dump_file.sql

[sdousley]

you will also need to ensure that the username that the phpBB scripts use to connect to the database exist on the new server aswell

[zachtib]

awesome. once i restore the database, I'll just copy the /var/www/html files over from my old server, correct?

[Sygnus X1]

im no server genious, but yes, i blieve this should work

1. back up you db
2. back up your server files (var/www/html)
3. copy contents of var/www/html tp the new server html folder
4. take the .sql file that you made when you backed up your db and put it in thru phpMyAdmin or whatever you use and inject it into the new SQL server.
5. check and make sure everything checks out with ur configureation file in phpBB- like that the logins match the new db's logins and stuff
6. make sure everything works
7. you should be done

[zachtib]

great, I'll be trying this shortly. obviously, I'll leave the first server up until I know the new one works, so if i screw up, its not the end of the world. thanks, all. Ill post back here if i run into any trouble

[Pandaboy]

Great, this is exactly what I"m looking for
I've read all these posts, but I see no one talked about moving the members list

Is there a way to copy all the member list to a new server as well?

[jledhead]

Is there a way to copy all the member list to a new server as well?

if your talking about linux users, I have used webmin to sync users from machine to machine.

for mysql I would say just create the new users