help needed with phpbb

[DrFraggle]

my question for all is how do you get your forum to move to another site without losing posts, members, etc?

 

[amalfra]

do you mean changing hosts or changing from phpbb to any other softwares ?

 

[DrFraggle]

moving the files from one host to another host

 

[amalfra]

some of the hosts like hostgator provide free website transfers from other hosts. contact your new host to see if they offer one . if yes , then they would do that for you ,otherwise you would have to upload all your files to new host and import the sql tables from your current host.

 

[Deleted member 1609]

I've moved this to Forum & Hosting Support. 🙂

 

[master412160]

1. You close down your board so no new topics, posts or such can be made.

2. You make a copy of your files through making it a zip file through file manager and extraing sql database through phpmyadmin.

3. In the new host its cpanel I assume you just do the steps that you did on the cpanel of your current host for getting the forum up and running.

Note: Be sure to check config.php its in the root when having issues.

 

[remonray]

I just moved my forum from www.example.com/forum to www.example.com
For that I just copy all the files from /forum to root folder and that worked.

I am not sure if this works for changing hosts....

 

[Dumindu]

Its simple. First save a back up of your web files and database to your PC.
Then upload the files and database to your new host. Although the restore is not succeeded, still you have the files in your PC. Therefore no worries.

 

[sapper]

Its simple. First save a back up of your web files and database to your PC.
Then upload the files and database to your new host. Although the restore is not succeeded, still you have the files in your PC. Therefore no worries.

You have to alter config.php to point to the database on the new installation as well though

 

[DrFraggle]

when I use phpMyAdmin to transfer my forum I get this error



Error
SQL query:

--
-- Database: `u279285699_mysql`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpbb_acl_groups`
--
CREATE TABLE IF NOT EXISTS `phpbb_acl_groups` (

`group_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`forum_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`auth_option_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`auth_role_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`auth_setting` TINYINT( 2 ) NOT NULL DEFAULT '0',
KEY `group_id` ( `group_id` ) ,
KEY `auth_opt_id` ( `auth_option_id` ) ,
KEY `auth_role_id` ( `auth_role_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

MySQL said:

#1046 - No database selected

 

[pandaa]

Why didn't you just make a database copy, install phpBB at your new location, then restore to it?

 

[DrFraggle]

I tried that route, for some reason it didn't work until just a few min ago, I did a search on google, followed the instructions I had found and got the sql file to transfer, now all I gotta do is get my users to show up under the members link

 

[Patrick W.]

Once you have the database transferred log into you ACP and click on the following:

Resynchronise statistics
Resynchronise post counts
Purge the cache

That should sort the members and posts not calculating. 🙂

 

[DrFraggle]

Patrick, that didn't work

 

[Patrick W.]

Hmm...sending you a PM.

 

[Pvt_Tracy]

I helped him with everything I could, I even tried exporting different ways and then importing them. It has fried my brain. I told him to get with you on what you mentioned in your PM Patrick. I thought maybe something he has running on his system was interfering with the transfers and told him to try on my system and got the same thing.

 

[DrFraggle]

please mark this as SOLVED

I finally figured it out, I had to manually install phpbb then upload everything else for it to take, please visit my new forum here http://www.drfraggle.usa.cc/phpBB3/

 

[xpl0iter]

Do you have cpanel?
In that case take a full backup of your site and give that backup file to your new host(if they also have cpanel) and ask them to restore it. Most hosts would do it for free!