Find the answer to your Linux question:
Results 1 to 9 of 9
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User
    Join Date
    Dec 2004
    Location
    Speed School of Engineering
    Posts
    267

    Moving a phpBB forum to a new server


    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?

  2. #2
    Just Joined!
    Join Date
    Feb 2005
    Location
    Your SQL Server
    Posts
    95
    yes you can, i did this exact same thing, just move all the phpBB files over, and restore the databse. it is that easy

  3. #3
    Linux Newbie
    Join Date
    Dec 2004
    Location
    Barrie, Ontario
    Posts
    219
    Code:
    mysql -u &#91;username&#93; -D &#91;database&#93; -p  < dump_file.sql
    Blog - KB5UMQ - Linux User #272983
    3 Rules:
    1) "It doesn't work..." is simply not useful information.
    2) Don't cross post!
    3) If you are asking for help, start by telling us your distro/os and version.

  4. #4
    Linux Guru sdousley's Avatar
    Join Date
    Feb 2004
    Posts
    1,790
    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
    "I am not an alcoholic, alcoholics go to meetings"
    Registered Linux user = #372327

  5. #5
    Linux User
    Join Date
    Dec 2004
    Location
    Speed School of Engineering
    Posts
    267
    awesome. once i restore the database, I'll just copy the /var/www/html files over from my old server, correct?

  6. #6
    Just Joined!
    Join Date
    Dec 2004
    Posts
    50
    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

  7. #7
    Linux User
    Join Date
    Dec 2004
    Location
    Speed School of Engineering
    Posts
    267
    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

  8. #8
    Just Joined!
    Join Date
    May 2005
    Posts
    1
    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?

  9. #9
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    Quote Originally Posted by Pandaboy

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •