importing database from freeforums.org phpBB 2.0.x 2.0.x Support Forum Question

Question importing database from freeforums.org ( phpBB phpBB 2.0.x 2.0.x Support Forum )
Updated: 2008-11-23 05:55:01 (0)

importing database from freeforums.org

I'm completely lost. I had a forum on freeforums.org which I want to host for myself. They sent me the database and I have installed phpbb 3 on my server which is working but with no data.

I can't work out how to import the database from freeforums. It is a phpbb 2 database so but when I ran the convertor it wanted a path to the old forum... but of course the old forum isn't on my server. Do I need to install phpbb 2 and somehow upload my data to this and then convert to phpbb 3?

Answers: importing database from freeforums.org ( phpBB phpBB 2.0.x 2.0.x Support Forum )

importing database from freeforums.org

steveash wrote: Do I need to install phpbb 2 and somehow upload my data to this and then convert to phpbb 3?

Yes, that is exactly what you need to do.

Mac GUI City - A virtual world for Mac users.
Need help with anything phpBB? Send me a PM.
Dog Cow

importing database from freeforums.org

Thanks!

How do I import the database into phpbb2?
steveash

importing database from freeforums.org

First, you should install phpBB 2, then you can have a look at the manual here: http://www.phpbb.com/support/documentat ... ction3_2_1

Once phpBB 2 is installed, you access the admin panel, choose Restore Database, and give the backup file that you have.

Mac GUI City - A virtual world for Mac users.
Need help with anything phpBB? Send me a PM.
Dog Cow

importing database from freeforums.org

Great. Thanks a lot.
steveash

importing database from freeforums.org

I have installed PHPBB 2 - all went well. When I try to restore I get the following general error:

Filename problem; please try an alternative file phpbb_db_backup.sql

I tried several filenames including the above being the default backup file name. I'm guessing there is a problem with my database. If it helps here are the first few lines which look very different to the backup I just did from the new forum:

-- MySQL dump 10.10
--
-- Host: 10.16.22.196 Database: phpbb_109
-- ------------------------------------------------------
-- Server version 5.0.51a-community-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `myforum_search_results`
--

DROP TABLE IF EXISTS `myforum_search_results`;
CREATE TABLE `myforum_search_results` (
`search_id` int(11) unsigned NOT NULL default '0',
`session_id` char(32) NOT NULL default '',
`search_time` int(11) NOT NULL default '0',
`search_array` text NOT NULL,
PRIMARY KEY (`search_id`),
KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `myforum_search_results`
--
steveash

- Source: importing database from freeforums.org phpBB phpBB 2.0.x 2.0.x Support Forum
- Previous Question: Member Rank phpBB phpBB 3.0.x 3.0.x Support Forum
- Next Question: Multiple boards for single installation multiple databases phpBB phpBB 3.0.x 3.0.x Support Forum