Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 25, 2012, 06:02:49 AM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Fedup trying to move my forum  (Read 661 times)
Inge Jones
Intergalactic Superstar
*****
Offline Offline

Posts: 139
« on: March 13, 2005, 06:04:15 AM »
This is the 3rd webhosting company I have tried, in my attempt to find one that was reliable and good value.  I am very happy with it so far.

But I am having no luck porting my PHBB2 forums with me as I move. This will be the 3rd time I will have to ask my poor members to reregister and it seems absurd that PHBB2 was not written to cope with this through its admin panel.  I mean I would have thought it would be possible to have the backup and restore function look to the config files that contain the paths and database names, rather than have the paths embedded in the actual backup files!

Anyway - I can't get to the SQL database holding the forum data via the host I am moving from, so Extract database looks like a non-starter.

Is there any last thing I can try?
Logged
stephan
Guest
« Reply #1 on: March 13, 2005, 08:36:47 AM »
In the administration panel of phpbb, you can download a backup of the database (if your old hosting account is still active)

Or, you could e-mail the old host and ask them for a backup of it.
Logged
Inge Jones
Intergalactic Superstar
*****
Offline Offline

Posts: 139
« Reply #2 on: March 13, 2005, 08:44:03 AM »
But it seems you can't use a backup to move data from one location to another unfortunately.
Logged
Ryom
Spacescooter Operator
*****
Offline Offline

Posts: 39
« Reply #3 on: March 13, 2005, 08:14:53 PM »
You can move from one host to another easily with phpbb.

Use phpmyadmin on your other host to export the db or just use the admin panel database backup in phpbb. If you can't do either of those have your host export it for you and put it on your ftp.

Then Copy your forum dir from one host to the other and then edit your config.php file in the forum root which contains the db connect info, you'll have to change the information in it to match that of your new host if the db name and such has changed.

Then re-upload the db via the admin panel restore or phpmyadmin or use the ftp method in the knowledge base on phpbb.com

Alternately, search the phpbb forums for one of the literally hundreds of threads on this topic.
Logged
Inge Jones
Intergalactic Superstar
*****
Offline Offline

Posts: 139
« Reply #4 on: March 13, 2005, 11:59:26 PM »
I have searched the forum.  I always do that before starting a new query thread.  I was posting because *after* trying all the advice I found already, I found I couldn't do it that way.  The admin tools I have at the other site don't stretch to getting hold of the forum database, they point to some other directory where non-forum SQL databases are kept.

However, your message contains some ideas new to me.  I obtained the backup ok.   Is it just config.php I would need to edit after copying the directory over?
Logged
Ryom
Spacescooter Operator
*****
Offline Offline

Posts: 39
« Reply #5 on: March 14, 2005, 01:08:01 AM »
The only phpbb file you need to edit on the new server is config.php. You need to enter your new database info if the information has changed from your other host (which is likely).

Quote
The admin tools I have at the other site don't stretch to getting hold of the forum database, they point to some other directory where non-forum SQL databases are kept.


I don't understand this. You shouldn't need to rely 3rd party tools as phpbb has database backup built into it via the Admin Control Panel. The only reasons you wouldn't be able to use the tool built into phpbb's admin panel is if your other host has php setup incorrectly or has a quick time-out for scripts set. If they've done so then phpmyadmin export wouldn't work either.

You originally said you needed to get your forum db. Look in your config.php file and find the db name, then ask your other hosts support staff do this:

as ROOT from shell (or as mysql user with full privs)

mysqldump forumDBname > forum_backup.sql
gzip forum_backup.sql

and have them place the backup.sql in your non-webaccessable ftp root if you have one or in a passworded directory if your ftp only shows web-accessable areas. Download the forum_backup.sql and restore it either by having your new host import it for you, or via Admin Control Panel db restore in phpbb, or via phpmyadmin db import, or the ftp & admin_db_utilities.php edit method described in the phpbb.com knowledge base.
Logged
Inge Jones
Intergalactic Superstar
*****
Offline Offline

Posts: 139
« Reply #6 on: March 14, 2005, 01:29:21 AM »
Quote from: Ryom
I don't understand this. You shouldn't need to rely 3rd party tools as phpbb has database backup built into it via the Admin Control Panel.


Oh yes, no problem with obtaining the backup.   But I had understood from the results of my forum search that this was *not* the correct way to go about moving forum data between hosts.

Quote
You originally said you needed to get your forum db. Look in your config.php file and find the db name, then ask your other hosts support staff do this:


Lol - we can forget anything that requires help from a human being that end Very Happy   Why do you think I moved? Smile

Quote
Download the forum_backup.sql and restore it either by having your new host import it for you, or via Admin Control Panel db restore in phpbb, or via phpmyadmin db import, or the ftp & admin_db_utilities.php edit method described in the phpbb.com knowledge base.


Can I just recap:  You suggest I obtain a "full backup" (ie structure and data) from my existing forum.   I should then copy the phpbb2 directory from my old host over the top of my new one, preserving config.php as a guide to editing the one I copied over?

I think this is too difficult for me to get right.  Maybe if I give the backup to the staff here they could install it for me?
Logged
Ryom
Spacescooter Operator
*****
Offline Offline

Posts: 39
« Reply #7 on: March 14, 2005, 01:48:01 AM »
Just download your entire forum directory from your old host and then reupload it to lunarpages in the directory you want it.

Go into your Cpanel in lunarpages and click on the mysql databases link and create a new db. Check your config.php file and give your new db the same name, user, and pass if you can. That will make things easier.

Then have lp support import your backed up database info into your newly made database. If you were able to keep your db name, user, and pass the same, your forum should work normally once they are done. It's really that easy.

There might be one more step you need to do, and that would be to chmod 766 your images directory so people can upload avatars and whatnot, and the same for the files directory if you have the attachement mod installed. You can have lp support do it for you if you don't know how.
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: