Jump to content


Moving Phpbb2 From Your Old Host To Tch

  • Please log in to reply
4 replies to this topic

#1 greenbriel


    New To The Neighborhood

  • Members
  • Pip
  • 15 posts

Posted 17 May 2004 - 02:17 PM

I had this exact problem, and thought I'd post how it worked for me in the hopes it might save some TCHers a bit of messing around. It's actually really simple once you know the steps.

First of all, ftp down all your phpBB2 directories from the old host, and then upload them to TCH.

Then back up the MySQL database on the old host (mine used webmin, not cpanel/phpMyAdmin, but it still worked fine), then import the database using phpMyAdmin on the new host. Create your database first on the new host, then add a user and connect it to the databse. Make a note of the names because they get converted, i.e. if your username is foo, and you make a database or user called foobar, you'll get foo_foobar.

BIG IMPORTANT PART - you MUST open the database backup and look for any line with a bunch of dashes and either remove it, or put a space after the first two dashes, i.e.

-- -------------------

Not sure why this happens, but you need to add the space to turn that line into a commment, which will be ignored, rather than a line of data, which will choke the import.

So, now import your cleaned up data into your new database using phpMyAdmin (open the query window, then hit 'import files').

Now the only thing you should need to do is open your local copy of config.php, open in a text editor, ignore the lines that say "Do not change anything in this file' and edit $dbname, $dbuser (and $dbpassword, if you changed it), to match the new names, and upload to TCH, overwriting the one on the server.

You're done!

PS - I used a very similar procedure to move over my LARGE Movable Type blog with a minimum of fuss. Now just trying to figure out why my mtamazon plugin isn't cooperating.

PPS - this is what worked for me, I take no responsibility whatsoever if you destroy your database, accidentally email your entire pr0n collection to everyone in your address book, or blow yourself up. :P

#2 TCH-Don


    Immediate Family

  • Members
  • PipPipPipPip
  • 11,642 posts

Posted 17 May 2004 - 06:10 PM

Gabe, thank you Thumbs Up

I am sure this will be very helpful for anyone wanting
to move their forum or other database driven content.

#3 jakemtl


    New To The Neighborhood

  • Members
  • Pip
  • 18 posts

Posted 23 May 2004 - 04:25 PM

I just had a similar issue and restored my forums in the following manner:

1. I copied my entire phpbb directory onto the new server (TotalChoice)
2. I created a new database and username
3. I gave ALL priveleges to the username for the database
4. I modified my config.php file to reflect the new dbhost, dbusername and dbpasswd and uploaded it to the server, overwriting my old config.php file
5. From cPanel I went into mysql account maintenace and loaded phpmyadmin
6. In phpmyadmin I clicked on "databases" (In menu "Show Processes" , "Databases" , "Export" , "Log out". I then clicked on my database name and then the "SQL" tab. I chose to load up a text file by clicking "Browse". This text file was the .sql backup generated by the built-in backup function in phpbb. (My old host did not have phpmyadmin so I was backing up my database using the phpbb backup function in the administration section of phpbb).
7. I connected to my new phpbb site! Everything seems to work great!

#4 rockyrock


    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 15 November 2011 - 02:12 AM

really well-planed form of restoring)) if i 'll think about doing the same will follow your tipps)))

#5 wowsr

  • Members
  • 1 posts

Posted 19 December 2011 - 09:28 AM

I also recently had to move my forum to another host and I found that jakemtl's method worked best for me. Both guides have nicely laid out steps that anyone can follow. So thanks, this helped me out quite a bit.

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users